Attachments: Sawtooth Hanger

وحدة تحكم تشخيص الأخطاء لجوملا

الدورة

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732272864,
                "last": 1732272864,
                "now": 1732272864
            },
            "token": "EYZ3a5poH9nLsu9Y10ZgYVs7cdewkkQz"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "ar-AA"
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 705,
        "vmcartlastVendorId": 1,
        "vmlastvisitedcategoryid": 3,
        "vmlastvisitedproductids": [
            723
        ]
    }
}

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

التوضيح غير ممكن للإستعلام: INSERT INTO `josp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'65326d333773713364666c716f68663761386934627231376c31', 1, 1732272864, 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.14 ms
end	0.00 ms
query end	0.03 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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.75 ms قبل آخر إستعلام: 1.26 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 1.782 MB إرجاع الصفوف: 42

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

  FROM `josp_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	josp_extensions	NULL	ref	extension	extension	82	const	42	1.00	Using where

البروفايل

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

استدعاء المخزن

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

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.37 ms قبل آخر إستعلام: 1.41 ms إستعلام الذاكرة: 0.015 MB الذاكرة بعد الإستعلام: 1.881 MB إرجاع الصفوف: 5

SELECT id, rules

  FROM `josp_viewlevels`

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_viewlevels	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	5	100.00	NULL

البروفايل

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.20 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.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:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.70 ms قبل آخر إستعلام: 0.21 ms إستعلام الذاكرة: 0.015 MB الذاكرة بعد الإستعلام: 1.905 MB إرجاع الصفوف: 2

SELECT b.id

  FROM josp_usergroups AS a

  LEFT JOIN josp_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.01 ms
checking permissions	0.00 ms
Opening tables	0.46 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 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.02 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:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.80 ms قبل آخر إستعلام: 0.42 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 1.944 MB إرجاع الصفوف: 112

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

  FROM josp_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	josp_extensions	NULL	ref	extension	extension	82	const	152	0.60	Using index condition; Using where; استعمال ترتيب الملفات

البروفايل

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.53 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	نفس الاستدعاء في خط أدناه.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 3.57 ms قبل آخر إستعلام: 14.41 ms إستعلام الذاكرة: 0.018 MB الذاكرة بعد الإستعلام: 2.650 MB إرجاع الصفوف: 2

SELECT *

  FROM josp_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	josp_languages	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	2	50.00	Using where; استعمال ترتيب الملفات

البروفايل

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
Opening tables	0.20 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.34 ms قبل آخر إستعلام: 0.56 ms إستعلام الذاكرة: 0.015 MB الذاكرة بعد الإستعلام: 2.672 MB إرجاع الصفوف: 4

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

  FROM `josp_extensions`

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

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using where

البروفايل

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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 2.17 ms قبل آخر إستعلام: 20.68 ms إستعلام الذاكرة: 0.069 MB الذاكرة بعد الإستعلام: 2.872 MB إرجاع الصفوف: 230

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

  LEFT JOIN josp_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	352	8.86	Using where; استعمال ترتيب الملفات
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.m.component_id	1	100.00	Using where

البروفايل

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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	نفس الاستدعاء في خط أدناه.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	نفس الاستدعاء في خط أدناه.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.77 ms قبل آخر إستعلام: 26.24 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.897 MB إرجاع الصفوف: 1

SHOW TABLES LIKE "josp_virtuemart_configs"

التوضيح

التوضيح غير ممكن للإستعلام: SHOW TABLES LIKE "josp_virtuemart_configs"

البروفايل

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.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
checking permissions	1.50 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:727
14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:580
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:415
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:947
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.39 ms قبل آخر إستعلام: 0.31 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 4.930 MB إرجاع الصفوف: 1

SELECT `config` 
  FROM `josp_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_configs	NULL	system	PRIMARY	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	1	100.00	NULL

البروفايل

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.19 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 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.03 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:455
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:947
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.02 ms قبل آخر إستعلام: 1.43 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 5.051 MB إرجاع الصفوف: 42

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

  FROM `josp_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jnews','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_vmmigrate','com_wrapper')

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_assets	NULL	ALL	idx_asset_name	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	243	17.70	Using where

البروفايل

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.41 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
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/administrator/components/com_virtuemart/helpers/vmaccess.php:136
14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:477
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:947
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.61 ms قبل آخر إستعلام: 1.14 ms إستعلام الذاكرة: 0.033 MB الذاكرة بعد الإستعلام: 5.164 MB إرجاع الصفوف: 6

SELECT id, home, template, s.params

  FROM josp_template_styles as s

  LEFT JOIN josp_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	7	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	bulkbins_markwalt_joom567.e.element	1	66.67	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.00 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:852
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:970
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.01 ms قبل آخر إستعلام: 2.04 ms إستعلام الذاكرة: 0.036 MB الذاكرة بعد الإستعلام: 5.244 MB إرجاع الصفوف: 52

SELECT * 
  FROM `josp_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and (language="*" or language = "ar-AA" )  
  AND client_id=0 
  AND published=1 
  AND ( access="1" OR access="5" )  
  ORDER BY `language` DESC

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_menu	NULL	ALL	idx_client_id_parent_id_alias_language,idx_language	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	352	0.28	Using where; استعمال ترتيب الملفات

البروفايل

Status	Duration
starting	0.04 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.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.73 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/components/com_virtuemart/router.php:1405
14	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:920
13	vmrouterHelper->setRoutingQuery()	JROOT/components/com_virtuemart/router.php:898
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:970
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.39 ms قبل آخر إستعلام: 1.01 ms إستعلام الذاكرة: 0.019 MB الذاكرة بعد الإستعلام: 5.279 MB إرجاع الصفوف: 1

SELECT l.virtuemart_product_id  
  FROM `josp_virtuemart_products_en_gb` as l  
  WHERE l.slug = "sawtooth-hanger_52-OOS"

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	const	slug	slug	578	const	1	100.00	NULL

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.04 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1333
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1271
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:719
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.25 ms قبل آخر إستعلام: 3.36 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 5.736 MB إرجاع الصفوف: 1

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

  FROM `josp_extensions`

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

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_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.06 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.02 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	نفس الاستدعاء في خط أدناه.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.25 ms قبل آخر إستعلام: 0.28 ms إستعلام الذاكرة: 0.012 MB الذاكرة بعد الإستعلام: 5.738 MB

UPDATE `josp_extensions`

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

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

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	josp_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.04 ms
updating	0.05 ms
end	0.00 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.45 ms قبل آخر إستعلام: 11.77 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 6.754 MB إرجاع الصفوف: 1

SELECT * 
  FROM `josp_virtuemart_shoppergroups` 
  WHERE `default` = "2" 
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
  AND `published`="1"

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_shoppergroups	NULL	ref	virtuemart_vendor_id,shared,published	published	1	const	5	16.67	Using where

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.19 ms
init	0.02 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.04 ms
end	0.00 ms
query end	0.01 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:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:186
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:176
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.17 ms قبل آخر إستعلام: 0.26 ms إستعلام الذاكرة: 0.030 MB الذاكرة بعد الإستعلام: 6.821 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_shoppergroups`.*  
  FROM `josp_virtuemart_shoppergroups`  
  WHERE `josp_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

التوضيح

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

البروفايل

Status	Duration
starting	0.02 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.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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1024
16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:186
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:176
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.83 ms قبل آخر إستعلام: 2.58 ms إستعلام الذاكرة: 0.032 MB الذاكرة بعد الإستعلام: 7.040 MB إرجاع الصفوف: 32

SHOW FULL COLUMNS  
  FROM `josp_virtuemart_userfields`

التوضيح

التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `josp_virtuemart_userfields`

البروفايل

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.25 ms
checking permissions	0.03 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.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.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.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.01 ms
Sending data	0.10 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:688
19	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
18	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:211
17	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432
16	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394
15	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:607
14	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
13	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:559
12	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:344
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:231
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.55 ms قبل آخر إستعلام: 0.32 ms إستعلام الذاكرة: 0.037 MB الذاكرة بعد الإستعلام: 7.134 MB إرجاع الصفوف: 28

SELECT * 
  FROM `josp_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`="1" 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type') = 0  
  ORDER BY ordering

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_userfields	NULL	ref	published,account	published	1	const	33	82.93	Using index condition; Using where; استعمال ترتيب الملفات

البروفايل

Status	Duration
starting	0.04 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.04 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.28 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/administrator/components/com_virtuemart/helpers/vmmodel.php:503
14	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
13	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:486
12	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:385
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:231
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.40 ms قبل آخر إستعلام: 17.50 ms إستعلام الذاكرة: 0.034 MB الذاكرة بعد الإستعلام: 8.264 MB إرجاع الصفوف: 14

SELECT * 
  FROM `josp_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `shipment`="1" 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_userfields	NULL	ref	published,shipment	shipment	1	const	14	80.49	Using index condition; Using where; استعمال ترتيب الملفات

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.14 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/administrator/components/com_virtuemart/helpers/vmmodel.php:503
14	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
13	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:492
12	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:385
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:231
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.33 ms قبل آخر إستعلام: 1.25 ms إستعلام الذاكرة: 0.034 MB الذاكرة بعد الإستعلام: 8.513 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_products`.* ,`josp_virtuemart_products_en_gb`.*  
  FROM `josp_virtuemart_products` 
  INNER JOIN `josp_virtuemart_products_en_gb` 
  ON `josp_virtuemart_products`.`virtuemart_product_id` = `josp_virtuemart_products_en_gb`.`virtuemart_product_id`  
  WHERE `josp_virtuemart_products`.`virtuemart_product_id` = "723"

التوضيح

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

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
init	0.03 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.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1565
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1124
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.42 ms قبل آخر إستعلام: 0.88 ms إستعلام الذاكرة: 0.019 MB الذاكرة بعد الإستعلام: 8.625 MB إرجاع الصفوف: 1

SELECT `virtuemart_media_id` 
  FROM `josp_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "723" 
  ORDER BY `ordering`

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_product_medias	NULL	ref	virtuemart_product_id,ordering	ordering	4	const	1	100.00	Using index condition

البروفايل

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.18 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
Sorting result	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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1588
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1124
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.52 ms قبل آخر إستعلام: 0.43 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 8.647 MB إرجاع الصفوف: 1

SELECT * 
  FROM `josp_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "723"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-11-22 10:54:24" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-11-22 10:54:24" ) ) 
  ORDER BY `product_price` DESC

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_product_prices	NULL	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	99.60	Using index condition; Using where; استعمال ترتيب الملفات

البروفايل

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 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.02 ms
closing tables	0.03 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/administrator/components/com_virtuemart/models/product.php:1359
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1380
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1624
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1124
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.35 ms قبل آخر إستعلام: 0.57 ms إستعلام الذاكرة: 0.019 MB الذاكرة بعد الإستعلام: 8.716 MB إرجاع الصفوف: 1

SELECT `virtuemart_manufacturer_id` 
  FROM `josp_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "723"

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_product_manufacturers	NULL	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	100.00	Using index

البروفايل

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.04 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1629
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1124
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.51 ms قبل آخر إستعلام: 0.49 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 8.778 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_manufacturers`.* ,`josp_virtuemart_manufacturers_en_gb`.*  
  FROM `josp_virtuemart_manufacturers` 
  INNER JOIN `josp_virtuemart_manufacturers_en_gb` 
  ON `josp_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `josp_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id`  
  WHERE `josp_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_manufacturers	NULL	const	PRIMARY,virtuemart_manufacturercategories_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	josp_virtuemart_manufacturers_en_gb	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.26 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 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.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1639
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1124
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.30 ms قبل آخر إستعلام: 0.36 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 8.808 MB إرجاع الصفوف: 2

SELECT * 
  FROM `josp_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 723

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_product_categories	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	2	100.00	NULL

البروفايل

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 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/administrator/components/com_virtuemart/models/product.php:1927
13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1904
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1652
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1124
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.54 ms قبل آخر إستعلام: 0.54 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 8.900 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_categories`.* ,`josp_virtuemart_categories_en_gb`.*  
  FROM `josp_virtuemart_categories` 
  INNER JOIN `josp_virtuemart_categories_en_gb` 
  ON `josp_virtuemart_categories`.`virtuemart_category_id` = `josp_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `josp_virtuemart_categories`.`virtuemart_category_id` = "3"

التوضيح

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

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.27 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 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:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1908
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1652
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1124
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.23 ms قبل آخر إستعلام: 0.45 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 8.932 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_categories`.* ,`josp_virtuemart_categories_en_gb`.*  
  FROM `josp_virtuemart_categories` 
  INNER JOIN `josp_virtuemart_categories_en_gb` 
  ON `josp_virtuemart_categories`.`virtuemart_category_id` = `josp_virtuemart_categories_en_gb`.`virtuemart_category_id`  
  WHERE `josp_virtuemart_categories`.`virtuemart_category_id` = "6"

التوضيح

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

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1908
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1652
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1124
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.67 ms قبل آخر إستعلام: 1.17 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 9.011 MB إرجاع الصفوف: 1

SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`
		
  FROM `josp_virtuemart_customs` AS c 
  LEFT JOIN `josp_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE field.`virtuemart_product_id` IN (723) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering` ASC

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	field	NULL	ref	virtuemart_custom_id,virtuemart_product_id,unique_cust_prd_value	virtuemart_product_id	4	const	1	100.00	Using index condition; Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,published	PRIMARY	4	bulkbins_markwalt_joom567.field.virtuemart_custom_id	1	90.48	Using index condition; Using where

البروفايل

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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:157
11	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1219
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.56 ms قبل آخر إستعلام: 1.26 ms إستعلام الذاكرة: 0.034 MB الذاكرة بعد الإستعلام: 9.181 MB إرجاع الصفوف: 1

SELECT *  
  FROM `josp_virtuemart_currencies` AS c
			
  LEFT JOIN `josp_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency
			
  WHERE v.virtuemart_vendor_id = "1"

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v	NULL	system	PRIMARY,vendor_currency	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.29 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 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.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:323
16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2999
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1233
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.21 ms قبل آخر إستعلام: 0.90 ms إستعلام الذاكرة: 0.030 MB الذاكرة بعد الإستعلام: 9.297 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_currencies`.*  
  FROM `josp_virtuemart_currencies`  
  WHERE `josp_virtuemart_currencies`.`virtuemart_currency_id` = "144"

التوضيح

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

البروفايل

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.02 ms
preparing	0.00 ms
executing	0.02 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1024
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2999
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1233
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.05 ms قبل آخر إستعلام: 1.00 ms إستعلام الذاكرة: 0.045 MB الذاكرة بعد الإستعلام: 9.417 MB إرجاع الصفوف: 73

SELECT c.* 
  FROM josp_virtuemart_calcs as c  
  LEFT JOIN josp_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id  
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-11-22 10:54:24" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-11-22 10:54:24" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	76	18.26	Using where
1	SIMPLE	cs	NULL	index	virtuemart_calc_id	virtuemart_calc_id	8	NULL	1	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

البروفايل

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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:172
14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2999
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1233
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.47 ms قبل آخر إستعلام: 2.40 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 10.309 MB إرجاع الصفوف: 0

SELECT `josp_virtuemart_ratings`.*  
  FROM `josp_virtuemart_ratings`  
  WHERE `josp_virtuemart_ratings`.`virtuemart_product_id` = "723"

التوضيح

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

البروفايل

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1261
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.51 ms قبل آخر إستعلام: 0.62 ms إستعلام الذاكرة: 0.019 MB الذاكرة بعد الإستعلام: 10.339 MB إرجاع الصفوف: 0

SELECT p.`virtuemart_product_id` 
  FROM `josp_virtuemart_products` as p
				
  LEFT JOIN `josp_virtuemart_product_categories` as pc
				
  ON p.`virtuemart_product_id` = pc.`virtuemart_product_id`  
  WHERE p.`product_parent_id` = "723"  
  AND p.`published`="1" 
  GROUP BY p.`virtuemart_product_id` 
  ORDER BY p.pordering ASC

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	NULL	ref	PRIMARY,product_parent_id,published	product_parent_id	4	const	6	73.48	Using index condition; Using where; Using temporary; استعمال ترتيب الملفات
1	SIMPLE	pc	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	bulkbins_markwalt_joom567.p.virtuemart_product_id	1	100.00	Using index

البروفايل

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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/product.php:3357
12	VirtueMartModelProduct->getUncategorizedChildren()	JROOT/templates/sj_remoz/html/com_virtuemart/sublayouts/customfield.php:262
11	VirtueMartCustomFieldRenderer::renderCustomfieldsFE()	JROOT/administrator/components/com_virtuemart/models/customfields.php:885
10	VirtueMartModelCustomfields::displayProductCustomfieldFE()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:86
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.54 ms قبل آخر إستعلام: 1.76 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 10.482 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_medias`.*  
  FROM `josp_virtuemart_medias`  
  WHERE `josp_virtuemart_medias`.`virtuemart_media_id` = "267"

التوضيح

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

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 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.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:484
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1188
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:157
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.33 ms قبل آخر إستعلام: 0.90 ms إستعلام الذاكرة: 0.017 MB الذاكرة بعد الإستعلام: 10.556 MB إرجاع الصفوف: 1

SELECT p.`virtuemart_product_id`, `l`.`product_name`,`p`.product_sku 
  FROM `josp_virtuemart_products` as p 
  LEFT JOIN `josp_virtuemart_products_en_gb` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `josp_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `josp_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
  LEFT JOIN `josp_virtuemart_categories` as c 
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`  
  WHERE ( `pc`.`virtuemart_category_id` = 3 
  AND  `c`.`published` = 1  
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="723"  
  AND `p`.product_sku <= "52-OOS"  
  ORDER BY `p`.product_sku DESC, p.`virtuemart_product_id` DESC 
  LIMIT 1

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	Using temporary; استعمال ترتيب الملفات
1	SIMPLE	pc	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	262	9.96	Using where; Using index
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published,product_sku	PRIMARY	4	bulkbins_markwalt_joom567.pc.virtuemart_product_id	1	34.64	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.pc.virtuemart_product_id	1	100.00	NULL
1	SIMPLE	ps	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	14	19.00	Using where; Using index; Using join buffer (Block Nested Loop)

البروفايل

Status	Duration
starting	0.07 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.20 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.15 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.55 ms
Creating sort index	0.06 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.02 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:178
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.81 ms قبل آخر إستعلام: 0.15 ms إستعلام الذاكرة: 0.017 MB الذاكرة بعد الإستعلام: 10.574 MB إرجاع الصفوف: 1

SELECT p.`virtuemart_product_id`, `l`.`product_name`,`p`.product_sku 
  FROM `josp_virtuemart_products` as p 
  LEFT JOIN `josp_virtuemart_products_en_gb` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `josp_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `josp_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
  LEFT JOIN `josp_virtuemart_categories` as c 
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`  
  WHERE ( `pc`.`virtuemart_category_id` = 3 
  AND  `c`.`published` = 1  
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="723" 
  AND p.`virtuemart_product_id`!="183" 
  AND `p`.product_sku >= "52-OOS"  
  ORDER BY `p`.product_sku ASC, p.`virtuemart_product_id` ASC 
  LIMIT 1

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	Using temporary; استعمال ترتيب الملفات
1	SIMPLE	pc	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	262	9.92	Using where; Using index
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published,product_sku	PRIMARY	4	bulkbins_markwalt_joom567.pc.virtuemart_product_id	1	38.91	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.pc.virtuemart_product_id	1	100.00	NULL
1	SIMPLE	ps	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	14	19.00	Using where; Using index; Using join buffer (Block Nested Loop)

البروفايل

Status	Duration
starting	0.07 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.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.32 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.02 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2215
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:178
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.41 ms قبل آخر إستعلام: 0.77 ms إستعلام الذاكرة: 0.018 MB الذاكرة بعد الإستعلام: 10.673 MB إرجاع الصفوف: 1

SELECT `virtuemart_media_id` 
  FROM `josp_virtuemart_manufacturer_medias` 
  WHERE `virtuemart_manufacturer_id` = "1" 
  ORDER BY `ordering`

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_manufacturer_medias	NULL	ref	virtuemart_manufacturer_id	virtuemart_manufacturer_id	4	const	1	100.00	Using index condition; استعمال ترتيب الملفات

البروفايل

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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/manufacturer.php:58
10	VirtueMartModelManufacturer->getManufacturer()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:187
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.21 ms قبل آخر إستعلام: 0.16 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 10.692 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_medias`.*  
  FROM `josp_virtuemart_medias`  
  WHERE `josp_virtuemart_medias`.`virtuemart_media_id` = "63"

التوضيح

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

البروفايل

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.03 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:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:484
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1188
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:188
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.35 ms قبل آخر إستعلام: 1.12 ms إستعلام الذاكرة: 0.018 MB الذاكرة بعد الإستعلام: 10.833 MB إرجاع الصفوف: 1

SELECT `virtuemart_media_id` 
  FROM `josp_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "3" 
  ORDER BY `ordering`

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_virtuemart_category_medias	NULL	ref	virtuemart_category_id,ordering	ordering	4	const	1	100.00	Using index condition

البروفايل

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.18 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:95
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:215
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.16 ms قبل آخر إستعلام: 0.15 ms إستعلام الذاكرة: 0.018 MB الذاكرة بعد الإستعلام: 10.846 MB إرجاع الصفوف: 1

SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  josp_virtuemart_categories 
				
  WHERE `virtuemart_category_id`= 3

التوضيح

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

البروفايل

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.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.00 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1044
11	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:977
10	VirtueMartModelCategory->getParentsList()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:216
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.21 ms قبل آخر إستعلام: 0.18 ms إستعلام الذاكرة: 0.017 MB الذاكرة بعد الإستعلام: 10.865 MB إرجاع الصفوف: 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `josp_virtuemart_categories` as c  
  LEFT JOIN `josp_virtuemart_categories_en_gb` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 3

التوضيح

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

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:998
10	VirtueMartModelCategory->getParentsList()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:216
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.19 ms قبل آخر إستعلام: 0.15 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 10.888 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_medias`.*  
  FROM `josp_virtuemart_medias`  
  WHERE `josp_virtuemart_medias`.`virtuemart_media_id` = "152"

التوضيح

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

البروفايل

Status	Duration
starting	0.02 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.03 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.02 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:484
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1188
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:219
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.56 ms قبل آخر إستعلام: 1.66 ms إستعلام الذاكرة: 0.018 MB الذاكرة بعد الإستعلام: 10.945 MB إرجاع الصفوف: 1

SELECT COLLATION_NAME 
  from information_schema.columns 
  where TABLE_SCHEMA = "bulkbins_markwalt_joom567"
				
  and TABLE_NAME = "josp_users"
				
  and COLUMN_NAME = "name";

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	columns	NULL	ALL	NULL	TABLE_SCHEMA,TABLE_NAME	NULL	NULL	NULL	NULL	Using where; Open_frm_only; Scanned 0 databases

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.03 ms
checking permissions	0.03 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.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.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/ratings.php:95
11	VirtueMartModelRatings::getSelect()	JROOT/administrator/components/com_virtuemart/models/ratings.php:229
10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:298
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.41 ms قبل آخر إستعلام: 0.10 ms إستعلام الذاكرة: 0.018 MB الذاكرة بعد الإستعلام: 10.962 MB إرجاع الصفوف: 1

SELECT COLLATION_NAME 
  from information_schema.columns 
  where TABLE_SCHEMA = "bulkbins_markwalt_joom567"
				
  and TABLE_NAME = "josp_virtuemart_rating_reviews"
				
  and COLUMN_NAME = "customer";

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	columns	NULL	ALL	NULL	TABLE_SCHEMA,TABLE_NAME	NULL	NULL	NULL	NULL	Using where; Open_frm_only; Scanned 0 databases

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.03 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.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.01 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.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/ratings.php:103
11	VirtueMartModelRatings::getSelect()	JROOT/administrator/components/com_virtuemart/models/ratings.php:229
10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:298
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.03 ms قبل آخر إستعلام: 0.14 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 10.982 MB إرجاع الصفوف: 0

SELECT  `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer   
  FROM `josp_virtuemart_rating_reviews` AS `pr`
			
  INNER JOIN `josp_virtuemart_products_en_gb` AS `l` 
  ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`  
  LEFT JOIN `josp_virtuemart_rating_votes` AS `rv` 
  on
			(`pr`.`virtuemart_rating_vote_id` IS NOT NULL 
  AND `rv`.`virtuemart_rating_vote_id`=`pr`.`virtuemart_rating_vote_id` ) XOR
			(`pr`.`virtuemart_rating_vote_id` IS NULL 
  AND (`rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id` 
  and `rv`.`created_by`=`pr`.`created_by`) )
			
  LEFT JOIN `josp_users` AS `u`	
  ON `pr`.`created_by` = `u`.`id` 
 
  WHERE  `pr`.`virtuemart_product_id` = "723" 

 
  ORDER BY created_on DESC 
  LIMIT 0, 5

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; استعمال ترتيب الملفات
1	SIMPLE	pr	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	Using index condition
1	SIMPLE	rv	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	8	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.pr.created_by	1	100.00	NULL

البروفايل

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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:869
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/ratings.php:230
10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:298
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.38 ms قبل آخر إستعلام: 3.28 ms إستعلام الذاكرة: 0.032 MB الذاكرة بعد الإستعلام: 11.178 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 josp_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_virtuemart.productdetails' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; استعمال ترتيب الملفات
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	bulkbins_markwalt_joom567.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.a.group_id	1	100.00	Using where

البروفايل

Status	Duration
starting	0.09 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.01 ms
Opening tables	0.65 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.19 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.03 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	نفس الاستدعاء في خط أدناه.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:1085
10	shopFunctionsF::triggerContentPlugin()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:353
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 1.11 ms قبل آخر إستعلام: 1.27 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 11.306 MB إرجاع الصفوف: 1

SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
				j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
  FROM josp_virtuemart_shipmentmethods as i 
 
  LEFT JOIN `josp_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
 
  LEFT JOIN `josp_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `josp_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
  WHERE i.`published` = "1" 
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
									
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_shipmentmethod_id` 
  ORDER BY i.`ordering`

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	system	virtuemart_shipmentmethod_id	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	0	0.00	const row not found
1	SIMPLE	i	NULL	ALL	PRIMARY	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	2	50.00	Using where; Using temporary; استعمال ترتيب الملفات
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.i.virtuemart_shipmentmethod_id	1	100.00	NULL
1	SIMPLE	j	NULL	eq_ref	PRIMARY	PRIMARY	4	bulkbins_markwalt_joom567.i.shipment_jplugin_id	1	100.00	NULL

البروفايل

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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:532
14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:361
13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	نفس الاستدعاء في خط أدناه.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.32 ms قبل آخر إستعلام: 4.52 ms إستعلام الذاكرة: 0.048 MB الذاكرة بعد الإستعلام: 11.680 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_products`.* ,`josp_virtuemart_products_en_gb`.*  
  FROM `josp_virtuemart_products` 
  INNER JOIN `josp_virtuemart_products_en_gb` 
  ON `josp_virtuemart_products`.`virtuemart_product_id` = `josp_virtuemart_products_en_gb`.`virtuemart_product_id`  
  WHERE `josp_virtuemart_products`.`virtuemart_product_id` = "183"

التوضيح

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

البروفايل

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 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.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
22	VmTable->load()	JROOT/components/com_virtuemart/router.php:1155
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:224
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/sj_remoz/html/com_virtuemart/productdetails/default.php:38
12	include JROOT/templates/sj_remoz/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:435
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.25 ms قبل آخر إستعلام: 0.73 ms إستعلام الذاكرة: 0.046 MB الذاكرة بعد الإستعلام: 11.724 MB إرجاع الصفوف: 1

SELECT `josp_virtuemart_products`.* ,`josp_virtuemart_products_en_gb`.*  
  FROM `josp_virtuemart_products` 
  INNER JOIN `josp_virtuemart_products_en_gb` 
  ON `josp_virtuemart_products`.`virtuemart_product_id` = `josp_virtuemart_products_en_gb`.`virtuemart_product_id`  
  WHERE `josp_virtuemart_products`.`virtuemart_product_id` = "206"

التوضيح

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

البروفايل

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 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.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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
22	VmTable->load()	JROOT/components/com_virtuemart/router.php:1155
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:224
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/sj_remoz/html/com_virtuemart/productdetails/default.php:43
12	include JROOT/templates/sj_remoz/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:435
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.18 ms قبل آخر إستعلام: 2.61 ms إستعلام الذاكرة: 0.034 MB الذاكرة بعد الإستعلام: 11.797 MB إرجاع الصفوف: 1

SELECT l.slug  
  FROM `josp_virtuemart_manufacturers_en_gb` as l  
  WHERE l.virtuemart_manufacturer_id = "1"

التوضيح

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

البروفايل

Status	Duration
starting	0.02 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.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.00 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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1333
24	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1287
23	vmrouterHelper->getManufacturerName()	JROOT/components/com_virtuemart/router.php:233
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/templates/sj_remoz/html/com_virtuemart/productdetails/default_manufacturer.php:26
14	include JROOT/templates/sj_remoz/html/com_virtuemart/productdetails/default_manufacturer.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/sj_remoz/html/com_virtuemart/productdetails/default.php:120
12	include JROOT/templates/sj_remoz/html/com_virtuemart/productdetails/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:435
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.46 ms قبل آخر إستعلام: 2.25 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 11.815 MB إرجاع الصفوف: 8

SHOW FULL COLUMNS 
  FROM `josp_template_styles`

التوضيح

التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `josp_template_styles`

البروفايل

Status	Duration
starting	0.02 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.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 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.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

استدعاء المخزن

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
10	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/helix3/helix3.php:37
8	plgSystemHelix3->onAfterDispatch()	نفس الاستدعاء في خط أدناه.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.19 ms قبل آخر إستعلام: 0.26 ms إستعلام الذاكرة: 0.016 MB الذاكرة بعد الإستعلام: 11.854 MB إرجاع الصفوف: 1

SELECT *

  FROM josp_template_styles

  WHERE `id` = '10'

التوضيح

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

البروفايل

Status	Duration
starting	0.02 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.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:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/helix3/helix3.php:38
8	plgSystemHelix3->onAfterDispatch()	نفس الاستدعاء في خط أدناه.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.44 ms قبل آخر إستعلام: 0.50 ms إستعلام الذاكرة: 0.015 MB الذاكرة بعد الإستعلام: 11.899 MB إرجاع الصفوف: 3

SELECT language,id

  FROM `josp_menu`

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

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_menu	NULL	ALL	idx_client_id_parent_id_alias_language	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	352	0.89	Using where

البروفايل

Status	Duration
starting	0.02 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.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.24 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:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
8	PlgSystemLanguageFilter->onAfterDispatch()	نفس الاستدعاء في خط أدناه.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

وقت الإستعلام: 0.68 ms قبل آخر إستعلام: 7.40 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 12.160 MB إرجاع الصفوف: 77

SELECT * 
  FROM josp_acymailing_config

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josp_acymailing_config	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	77	100.00	NULL

البروفايل

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

استدعاء المخزن

#	المتصل	الملف ورقم السطر
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:453
14	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
12	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:788
11	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
10	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
9	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
8	plgSystemRegacymailing->onAfterRender()	نفس الاستدعاء في خط أدناه.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

49 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً

تحديد الجداول:

3 × SELECT `josp_virtuemart_medias`.*  
  FROM `josp_virtuemart_medias`

3 × SELECT `josp_virtuemart_products`.* ,`josp_virtuemart_products_en_gb`.*  
  FROM `josp_virtuemart_products` 
  INNER JOIN `josp_virtuemart_products_en_gb` 
  ON `josp_virtuemart_products`.`virtuemart_product_id` = `josp_virtuemart_products_en_gb`.`virtuemart_product_id`

2 × SELECT COLLATION_NAME 
  from information_schema.columns

2 × SELECT * 
  FROM `josp_virtuemart_userfields`

2 × SELECT p.`virtuemart_product_id`, `l`.`product_name`,`p`.product_sku 
  FROM `josp_virtuemart_products` as p 
  LEFT JOIN `josp_virtuemart_products_en_gb` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `josp_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `josp_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
  LEFT JOIN `josp_virtuemart_categories` as c 
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`

2 × SELECT `josp_virtuemart_categories`.* ,`josp_virtuemart_categories_en_gb`.*  
  FROM `josp_virtuemart_categories` 
  INNER JOIN `josp_virtuemart_categories_en_gb` 
  ON `josp_virtuemart_categories`.`virtuemart_category_id` = `josp_virtuemart_categories_en_gb`.`virtuemart_category_id`

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

1 × SELECT `josp_virtuemart_ratings`.*  
  FROM `josp_virtuemart_ratings`

1 × SELECT *  
  FROM `josp_virtuemart_currencies` AS c    
  LEFT JOIN `josp_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency

1 × SELECT `josp_virtuemart_currencies`.*  
  FROM `josp_virtuemart_currencies`

1 × SELECT c.* 
  FROM josp_virtuemart_calcs as c  
  LEFT JOIN josp_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT `virtuemart_media_id` 
  FROM `josp_virtuemart_manufacturer_medias`

1 × SELECT p.`virtuemart_product_id` 
  FROM `josp_virtuemart_products` as p     
  LEFT JOIN `josp_virtuemart_product_categories` as pc     
  ON p.`virtuemart_product_id` = pc.`virtuemart_product_id`

1 × SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  josp_virtuemart_categories

1 × SELECT l.slug  
  FROM `josp_virtuemart_manufacturers_en_gb` as l

1 × SELECT * 
  FROM josp_template_styles

1 × SELECT language,id 
  FROM `josp_menu`

1 × SELECT * 
  FROM josp_acymailing_confi

1 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,     j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
  FROM josp_virtuemart_shipmentmethods as i   
  LEFT JOIN `josp_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`   
  LEFT JOIN `josp_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`    
  LEFT 
  OUTER JOIN `josp_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`

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

1 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,   c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,   field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`   
  FROM `josp_virtuemart_customs` AS c 
  LEFT JOIN `josp_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

1 × SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `josp_virtuemart_categories` as c  
  LEFT JOIN `josp_virtuemart_categories_en_gb` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id`

1 × SELECT  `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer   
  FROM `josp_virtuemart_rating_reviews` AS `pr`    
  INNER JOIN `josp_virtuemart_products_en_gb` AS `l` 
  ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`  
  LEFT JOIN `josp_virtuemart_rating_votes` AS `rv` 
  on    (`pr`.`virtuemart_rating_vote_id` IS NOT NULL 
  AND `rv`.`virtuemart_rating_vote_id`=`pr`.`virtuemart_rating_vote_id` ) XOR    (`pr`.`virtuemart_rating_vote_id` IS NULL 
  AND (`rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id` 
  and `rv`.`created_by`=`pr`.`created_by`) )    
  LEFT JOIN `josp_users` AS `u` 
  ON `pr`.`created_by` = `u`.`id`

1 × SELECT `virtuemart_media_id` 
  FROM `josp_virtuemart_category_medias`

1 × SELECT `josp_virtuemart_manufacturers`.* ,`josp_virtuemart_manufacturers_en_gb`.*  
  FROM `josp_virtuemart_manufacturers` 
  INNER JOIN `josp_virtuemart_manufacturers_en_gb` 
  ON `josp_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `josp_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id`

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

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

1 × SELECT `config` 
  FROM `josp_virtuemart_configs`

```
1 × SELECT * 
  FROM josp_languages 
```

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

1 × SELECT `session_id` 
  FROM `josp_session`

1 × SELECT id, rules 
  FROM `josp_viewlevels

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

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

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

1 × SELECT * 
  FROM `josp_virtuemart_product_prices`

1 × SELECT `virtuemart_manufacturer_id` 
  FROM `josp_virtuemart_product_manufacturers`

1 × SELECT `data` 
  FROM `josp_session`

1 × SELECT `virtuemart_media_id` 
  FROM `josp_virtuemart_product_medias`

1 × SELECT `josp_virtuemart_shoppergroups`.*  
  FROM `josp_virtuemart_shoppergroups`

```
1 × SELECT * 
  FROM `josp_menu` 
```

1 × SELECT l.virtuemart_product_id  
  FROM `josp_virtuemart_products_en_gb` as l

1 × SELECT * 
  FROM `josp_virtuemart_shoppergroups`

1 × SELECT * 
  FROM `josp_virtuemart_product_categories`

جداول أخرى:

1 × SHOW FULL COLUMNS 
  FROM `josp_template_styles

1 × SHOW FULL COLUMNS  
  FROM `josp_virtuemart_userfields

1 × UPDATE `josp_extensions` 
  SET `params` = '{\"mediaversion\":\"d48e6e9324189c93b6acd392951ee361\"}'

1 × SHOW TABLES LIKE "josp_virtuemart_configs

1 × INSERT INTO `josp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'65326d333773713364666c716f68663761386934627231376c31', 1, 1732272864, 0, '', 0

Sawtooth Hanger

Reviews

وحدة تحكم تشخيص الأخطاء لجوملا

الدورة

معلومات الملف الشخصي

الوقت

الذاكرة

الذاكرة المستخدمة

استعلامات قاعدة البيانات

58 الاستعلامات المسجلة 38.17 ms

49 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً

تحديد الجداول:

جداول أخرى: