Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1745926173,
                "last": 1745926173,
                "now": 1745926173
            }
        },
        "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
        }
    },
    "__vm": {
        "vmcartlastVendorId": 1,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":1,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":[],\"ST\":{\"address_type_name\":\"D\\u00e9nomination de l&#039;adresse\"},\"cartfields\":[],\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"fr-FR\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_redirected\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"OrderIdOrderDone\":false,\"orderdoneHtml\":false,\"virtuemart_order_id\":false,\"byDefaultBT\":[],\"byDefaultST\":{\"address_type_name\":1},\"productCartLoaded\":[],\"loadedCart\":true,\"lastAddedProduct\":0}",
        "vmlastvisitedItemid": 117,
        "vmlastvisitedcategoryid": 1,
        "vmlastvisitedproductids": [
            195
        ]
    }
}

EXPLAIN impossible sur la requête : INSERT INTO `jhkos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6365356362383132393337663739303439353662336435633162343061333939', 1, 1745926173, 0, '', 0)

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.93 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.118 MB Rangées retournées : 5

SELECT id, rules

  FROM `jhkos_viewlevels`

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jhkos_viewlevels	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.93 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.130 MB Rangées retournées : 2

SELECT b.id

  FROM jhkos_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.43 ms Après la dernière requête : 7.59 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.189 MB Rangées retournées : 1

SHOW TABLES LIKE "jhkos_virtuemart_configs"

Explication

EXPLAIN impossible sur la requête : SHOW TABLES LIKE "jhkos_virtuemart_configs"

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.48 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.29 ms
checking permissions	0.16 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:826
15	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:599
14	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:405
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:195
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:314
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:114
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.69 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.197 MB Rangées retournées : 1

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jhkos_virtuemart_configs	NULL	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.51 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	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.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:454
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:195
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:314
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:114
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.19 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.029 MB mémoire avant requête : 2.254 MB Rangées retournées : 41

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

  FROM `jhkos_assets`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jhkos_assets	NULL	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	96	43.75	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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:476
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:195
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:314
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:114
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.67 ms Après la dernière requête : 0.96 ms Mémoire de requête : 0.121 MB mémoire avant requête : 2.392 MB Rangées retournées : 47

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jhkos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	58	0.89	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1699
14	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:295
13	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:261
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:314
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:114
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.10 ms Après la dernière requête : 0.87 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.580 MB Rangées retournées : 1

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jhkos_virtuemart_shoppergroups	NULL	ref	virtuemart_vendor_id,shared,published	published	1	const	2	50.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:101
17	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
16	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
15	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
14	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1140
13	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1268
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.25 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.026 MB mémoire avant requête : 2.616 MB Rangées retournées : 1

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
20	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1161
19	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
18	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:109
17	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
16	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
15	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
14	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1140
13	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1268
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 4.10 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.040 MB mémoire avant requête : 2.644 MB Rangées retournées : 1

SELECT `jhkos_virtuemart_products`.* ,`jhkos_virtuemart_products_fr_fr`.*  
  FROM `jhkos_virtuemart_products` 
  INNER JOIN `jhkos_virtuemart_products_fr_fr` 
  ON `jhkos_virtuemart_products`.`virtuemart_product_id` = `jhkos_virtuemart_products_fr_fr`.`virtuemart_product_id`  
  WHERE `jhkos_virtuemart_products`.`virtuemart_product_id` = "195"

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1768
13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.34 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.680 MB Rangées retournées : 1

SELECT `virtuemart_media_id` 
  FROM `jhkos_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "195"  
  ORDER BY `ordering`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1801
13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.75 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.692 MB Rangées retournées : 1

SELECT * 
  FROM `jhkos_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "195"  
  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` <= "2025-04-29 11:29:33" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-29 11:29:33" ) ) 
  ORDER BY `product_price` DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jhkos_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	100.00	Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1577
15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1601
14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1831
13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.91 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.703 MB Rangées retournées : 1

SELECT * 
  FROM `jhkos_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 195

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2174
15	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:2151
14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1852
13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.16 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.735 MB Rangées retournées : 1

SELECT `jhkos_virtuemart_categories`.* ,`jhkos_virtuemart_categories_fr_fr`.*  
  FROM `jhkos_virtuemart_categories` 
  INNER JOIN `jhkos_virtuemart_categories_fr_fr` 
  ON `jhkos_virtuemart_categories`.`virtuemart_category_id` = `jhkos_virtuemart_categories_fr_fr`.`virtuemart_category_id`  
  WHERE `jhkos_virtuemart_categories`.`virtuemart_category_id` = "1"

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:2155
14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1852
13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 3.50 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.778 MB Rangées retournées : 0

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`,
		field.`product_sku`, field.`product_gtin`, field.`product_mpn`
		
  FROM `jhkos_virtuemart_customs` AS c 
  LEFT JOIN `jhkos_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE field.`virtuemart_product_id` IN (195) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering` ASC

Explication

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 where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,published	PRIMARY	4	oscarvision2017mc.field.virtuemart_custom_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:163
13	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1424
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.26 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.026 MB mémoire avant requête : 2.817 MB Rangées retournées : 1

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:316
18	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
17	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
16	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
14	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
13	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.22 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.026 MB mémoire avant requête : 2.857 MB Rangées retournées : 1

SELECT `jhkos_virtuemart_currencies`.*  
  FROM `jhkos_virtuemart_currencies`  
  WHERE `jhkos_virtuemart_currencies`.`virtuemart_currency_id` = "47"

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1161
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
16	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
14	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
13	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.05 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.036 MB mémoire avant requête : 2.970 MB Rangées retournées : 33

SHOW FULL COLUMNS  
  FROM `jhkos_virtuemart_userfields`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `jhkos_virtuemart_userfields`

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.59 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.46 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.06 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
27	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:787
26	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
25	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:239
24	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:441
23	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:403
22	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:620
21	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
20	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:572
19	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:381
18	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
17	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
14	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
13	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.18 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.038 MB mémoire avant requête : 3.012 MB Rangées retournées : 21

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jhkos_virtuemart_userfields	NULL	ref	published,account	account	1	const	23	92.86	Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:515
21	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
20	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:441
19	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
18	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
17	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
14	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
13	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.38 ms Après la dernière requête : 0.87 ms Mémoire de requête : 0.034 MB mémoire avant requête : 3.134 MB Rangées retournées : 14

SELECT * 
  FROM `jhkos_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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jhkos_virtuemart_userfields	NULL	ref	published,shipment	shipment	1	const	14	92.86	Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:515
21	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
20	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:447
19	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
18	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
17	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
14	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
13	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.80 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.227 MB Rangées retournées : 0

SELECT c.* 
  FROM jhkos_virtuemart_calcs as c  
  LEFT JOIN jhkos_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 (  ( ISNULL(`publish_up`) or `publish_up`="0000-00-00 00:00:00")  OR publish_up <= "2025-04-29 11:29:33" )
				
  AND (  ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00")  OR publish_down >= "2025-04-29 11:29:33" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) 
  ORDER BY c.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	100.00	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	cs	NULL	ref	virtuemart_calc_id	virtuemart_calc_id	4	oscarvision2017mc.c.virtuemart_calc_id	1	100.00	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:174
16	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:95
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
14	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
13	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
12	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1182
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:116
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.31 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.006 MB mémoire avant requête : 3.242 MB

UPDATE `jhkos_extensions`

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

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

Explication

EXPLAIN impossible sur la requête : UPDATE `jhkos_extensions` SET `params` = '{\"mediaversion\":\"cf66307415b91bd59cac8207f24dd2f8\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.80 ms
init	0.01 ms
System lock	0.09 ms
updating	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.20 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58
8	plgSystemDJjQueryMonster->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.79 ms Après la dernière requête : 5.02 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.829 MB Rangées retournées : 1

SELECT `jhkos_virtuemart_medias`.*  
  FROM `jhkos_virtuemart_medias`  
  WHERE `jhkos_virtuemart_medias`.`virtuemart_media_id` = "243"

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:566
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1321
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:159
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.69 ms Après la dernière requête : 1.92 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.992 MB Rangées retournées : 1

SELECT p.`virtuemart_product_id`, `pc`.ordering, `l`.product_name 
  FROM `jhkos_virtuemart_products` as p
 
  LEFT JOIN `jhkos_virtuemart_products_fr_fr` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `jhkos_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `jhkos_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` 

  WHERE ( `pc`.`virtuemart_category_id` IN (1)  
  AND 
  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND 
  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="195" 
 
  AND `pc`.ordering  >=  "0" 

  ORDER BY `pc`.ordering ASC, `l`.product_name ASC, `p`.virtuemart_product_id ASC  
  LIMIT 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pc	NULL	ref	virtuemart_product_id,virtuemart_category_id,ordering,virtuemart_product_id_uid,virtuemart_category_id_uid	virtuemart_category_id_uid	4	const	47	99.51	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	oscarvision2017mc.pc.virtuemart_product_id	1	10.00	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	oscarvision2017mc.pc.virtuemart_product_id	1	100.00	NULL
1	SIMPLE	ps	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	oscarvision2017mc.pc.virtuemart_product_id	1	100.00	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2532
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:180
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.76 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.999 MB Rangées retournées : 1

SELECT p.`virtuemart_product_id`, `pc`.ordering, `l`.product_name 
  FROM `jhkos_virtuemart_products` as p
 
  LEFT JOIN `jhkos_virtuemart_products_fr_fr` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `jhkos_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `jhkos_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` 

  WHERE ( `pc`.`virtuemart_category_id` IN (1)  
  AND 
  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND 
  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="195" 

  AND p.`virtuemart_product_id`!="178" 
  AND `pc`.ordering  <=  "0" 

  ORDER BY `pc`.ordering DESC, `l`.product_name DESC, `p`.virtuemart_product_id DESC  
  LIMIT 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pc	NULL	ref	virtuemart_product_id,virtuemart_category_id,ordering,virtuemart_product_id_uid,virtuemart_category_id_uid	virtuemart_category_id_uid	4	const	47	99.03	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	oscarvision2017mc.pc.virtuemart_product_id	1	10.00	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	oscarvision2017mc.pc.virtuemart_product_id	1	100.00	NULL
1	SIMPLE	ps	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	oscarvision2017mc.pc.virtuemart_product_id	1	100.00	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2532
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:180
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.99 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.058 MB Rangées retournées : 1

SELECT `virtuemart_media_id` 
  FROM `jhkos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "1"  
  ORDER BY `ordering`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:118
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.17 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.066 MB Rangées retournées : 1

SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  jhkos_virtuemart_categories 
				
  WHERE `virtuemart_category_id`= 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1095
13	VirtueMartModelCategory::getCategoryRecurseS()	JROOT/administrator/components/com_virtuemart/models/category.php:1018
12	VirtueMartModelCategory::getParents()	JROOT/administrator/components/com_virtuemart/models/category.php:1001
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:165
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.17 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.075 MB Rangées retournées : 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `jhkos_virtuemart_categories` as c  
  LEFT JOIN `jhkos_virtuemart_categories_fr_fr` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1041
12	VirtueMartModelCategory::getParents()	JROOT/administrator/components/com_virtuemart/models/category.php:1001
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:165
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.18 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.082 MB Rangées retournées : 1

SELECT `jhkos_virtuemart_medias`.*  
  FROM `jhkos_virtuemart_medias`  
  WHERE `jhkos_virtuemart_medias`.`virtuemart_media_id` = "177"

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:566
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1321
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:222
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 3.74 ms Après la dernière requête : 12.89 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.050 MB Rangées retournées : 0

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.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
  FROM jhkos_virtuemart_shipmentmethods as i 
 
  LEFT JOIN `jhkos_virtuemart_shipmentmethods_fr_fr` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
 
  LEFT JOIN `jhkos_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `jhkos_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` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	index	PRIMARY,shipment_jplugin_id,ordering,shipment_element	PRIMARY	4	NULL	1	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	oscarvision2017mc.i.virtuemart_shipmentmethod_id	1	100.00	NULL
1	SIMPLE	j	NULL	eq_ref	PRIMARY	PRIMARY	4	oscarvision2017mc.i.shipment_jplugin_id	1	100.00	NULL
1	SIMPLE	s	NULL	ref	virtuemart_shipmentmethod_id	virtuemart_shipmentmethod_id	4	oscarvision2017mc.i.virtuemart_shipmentmethod_id	1	100.00	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:513
14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:365
13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
10	vDispatcher::trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:370
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.44 ms Après la dernière requête : 3.60 ms Mémoire de requête : 0.045 MB mémoire avant requête : 5.489 MB Rangées retournées : 1

SELECT `jhkos_virtuemart_products`.* ,`jhkos_virtuemart_products_fr_fr`.*  
  FROM `jhkos_virtuemart_products` 
  INNER JOIN `jhkos_virtuemart_products_fr_fr` 
  ON `jhkos_virtuemart_products`.`virtuemart_product_id` = `jhkos_virtuemart_products_fr_fr`.`virtuemart_product_id`  
  WHERE `jhkos_virtuemart_products`.`virtuemart_product_id` = "174"

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
22	VmTable->load()	JROOT/components/com_virtuemart/router.php:1435
21	vmrouterHelper::getProductName()	JROOT/components/com_virtuemart/router.php:613
20	vmrouterHelper::buildRoute()	JROOT/components/com_virtuemart/router.php:79
19	VirtuemartRouter->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/components/com_virtuemart/views/productdetails/tmpl/bs5-default.php:85
12	include JROOT/components/com_virtuemart/views/productdetails/tmpl/bs5-default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.24 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.044 MB mémoire avant requête : 5.506 MB Rangées retournées : 1

SELECT `jhkos_virtuemart_products`.* ,`jhkos_virtuemart_products_fr_fr`.*  
  FROM `jhkos_virtuemart_products` 
  INNER JOIN `jhkos_virtuemart_products_fr_fr` 
  ON `jhkos_virtuemart_products`.`virtuemart_product_id` = `jhkos_virtuemart_products_fr_fr`.`virtuemart_product_id`  
  WHERE `jhkos_virtuemart_products`.`virtuemart_product_id` = "178"

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
22	VmTable->load()	JROOT/components/com_virtuemart/router.php:1435
21	vmrouterHelper::getProductName()	JROOT/components/com_virtuemart/router.php:613
20	vmrouterHelper::buildRoute()	JROOT/components/com_virtuemart/router.php:79
19	VirtuemartRouter->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/components/com_virtuemart/views/productdetails/tmpl/bs5-default.php:94
12	include JROOT/components/com_virtuemart/views/productdetails/tmpl/bs5-default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.28 ms Après la dernière requête : 1.08 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.564 MB Rangées retournées : 0

SELECT * 
  FROM `jhkos_virtuemart_ratings` 
  WHERE `virtuemart_product_id` = "195" 
  AND `published`="1"

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jhkos_virtuemart_ratings	NULL	ref	virtuemart_product_id,published	virtuemart_product_id	4	const	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/ratings.php:293
15	VirtueMartModelRatings->getRatingByProduct()	JROOT/components/com_virtuemart/sublayouts/snippets.php:24
14	include JROOT/components/com_virtuemart/sublayouts/snippets.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:569
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/productdetails/tmpl/bs5-default.php:310
12	include JROOT/components/com_virtuemart/views/productdetails/tmpl/bs5-default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
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:133
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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.46 ms Après la dernière requête : 3.55 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.804 MB Rangées retournées : 16

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

  FROM jhkos_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-04-29 11:29:33') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-29 11:29:33') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 117 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	38	2.63	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	oscarvision2017mc.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	oscarvision2017mc.m.module,const	1	10.00	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
10	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/libraries/src/Helper/ModuleHelper.php:126
9	Joomla\CMS\Helper\ModuleHelper::isEnabled()	JROOT/plugins/system/advanced_cookies_system/advanced_cookies_system.php:266
8	plgSystemadvanced_cookies_system->getmodparams()	JROOT/plugins/system/advanced_cookies_system/advanced_cookies_system.php:52
7	plgSystemadvanced_cookies_system->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

31 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

3 × SELECT `jhkos_virtuemart_products`.* ,`jhkos_virtuemart_products_fr_fr`.*  
  FROM `jhkos_virtuemart_products` 
  INNER JOIN `jhkos_virtuemart_products_fr_fr` 
  ON `jhkos_virtuemart_products`.`virtuemart_product_id` = `jhkos_virtuemart_products_fr_fr`.`virtuemart_product_id`

2 × SELECT `jhkos_virtuemart_medias`.*  
  FROM `jhkos_virtuemart_medias`

2 × SELECT p.`virtuemart_product_id`, `pc`.ordering, `l`.product_name 
  FROM `jhkos_virtuemart_products` as p  
  LEFT JOIN `jhkos_virtuemart_products_fr_fr` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `jhkos_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `jhkos_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`

2 × SELECT * 
  FROM `jhkos_virtuemart_userfields`

1 × SELECT `data` 
  FROM `jhkos_session`

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

1 × SELECT * 
  FROM `jhkos_virtuemart_ratings`

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.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
  FROM jhkos_virtuemart_shipmentmethods as i   
  LEFT JOIN `jhkos_virtuemart_shipmentmethods_fr_fr` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`   
  LEFT JOIN `jhkos_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`    
  LEFT 
  OUTER JOIN `jhkos_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`

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

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

1 × SELECT `virtuemart_media_id` 
  FROM `jhkos_virtuemart_category_medias`

1 × SELECT c.* 
  FROM jhkos_virtuemart_calcs as c  
  LEFT JOIN jhkos_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT `jhkos_virtuemart_currencies`.*  
  FROM `jhkos_virtuemart_currencies`

1 × SELECT `jhkos_virtuemart_categories`.* ,`jhkos_virtuemart_categories_fr_fr`.*  
  FROM `jhkos_virtuemart_categories` 
  INNER JOIN `jhkos_virtuemart_categories_fr_fr` 
  ON `jhkos_virtuemart_categories`.`virtuemart_category_id` = `jhkos_virtuemart_categories_fr_fr`.`virtuemart_category_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`,   field.`product_sku`, field.`product_gtin`, field.`product_mpn`   
  FROM `jhkos_virtuemart_customs` AS c 
  LEFT JOIN `jhkos_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

1 × SELECT `session_id` 
  FROM `jhkos_session`

1 × SELECT * 
  FROM `jhkos_virtuemart_product_categories`

1 × SELECT * 
  FROM `jhkos_virtuemart_product_prices`

1 × SELECT `virtuemart_media_id` 
  FROM `jhkos_virtuemart_product_medias`

1 × SELECT `jhkos_virtuemart_shoppergroups`.*  
  FROM `jhkos_virtuemart_shoppergroups`

1 × SELECT * 
  FROM `jhkos_virtuemart_shoppergroups`

```
1 × SELECT * 
  FROM `jhkos_menu`
```

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

1 × SELECT `config` 
  FROM `jhkos_virtuemart_configs`

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

1 × SELECT id, rules 
  FROM `jhkos_viewlevels

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

Autres tables :

1 × INSERT INTO `jhkos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6365356362383132393337663739303439353662336435633162343061333939', 1, 1745926173, 0, '', 0

1 × SHOW TABLES LIKE "jhkos_virtuemart_configs

1 × SHOW FULL COLUMNS  
  FROM `jhkos_virtuemart_userfields

1 × UPDATE `jhkos_extensions` 
  SET `params` = '{\"mediaversion\":\"cf66307415b91bd59cac8207f24dd2f8\"}'

CORDON D'ENFANT

Description du produit

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

36 requêtes exécutées 48.73 ms

31 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

Autres tables :