HB 16

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1780984797,
                "last": 1780984797,
                "now": 1780984797
            }
        },
        "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": {
        "vmlastvisitedItemid": 162,
        "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'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}",
        "vmlastvisitedcategoryid": 39,
        "vmlastvisitedproductids": [
            123
        ]
    }
}

Temps

Mémoire

33 requêtes exécutées 48.64 ms

1. Temps de requête : 1.94 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.542 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `jhkos_session`
   
     WHERE `session_id` = X'3639616330643938616634346331343935373762396266663737616331306230'

   Explication

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

   Profil

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	1.53 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.03 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:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   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]

   ---

2. Temps de requête : 0.17 ms Après la dernière requête : 1.15 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.631 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `jhkos_session`
   
     WHERE `session_id` = X'3639616330643938616634346331343935373762396266663737616331306230' 
     LIMIT 1

   Explication

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

   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.02 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
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Temps de requête : 0.54 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.004 MB mémoire avant requête : 3.636 MB

   INSERT INTO `jhkos_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3639616330643938616634346331343935373762396266663737616331306230', 1, 1780984797, 0, '', 0)

   Explication

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

   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
   update	0.12 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.30 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]

   ---

4. Temps de requête : 1.29 ms Après la dernière requête : 4.45 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.143 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	1.08 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 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]

   ---

5. Temps de requête : 1.39 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.156 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	1.09 ms
   init	0.01 ms
   System lock	0.01 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.01 ms
   closing tables	0.04 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]

   ---

6. Temps de requête : 1.63 ms Après la dernière requête : 32.29 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.997 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.08 ms
   Executing hook on transaction	0.01 ms
   starting	0.04 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.63 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.13 ms
   preparing	0.02 ms
   Creating tmp table	0.03 ms
   executing	0.29 ms
   checking permissions	0.11 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 ms
   freeing items	0.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]

   ---

7. Temps de requête : 1.10 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.004 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.88 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 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.05 ms
   freeing items	0.04 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: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]

   ---

8. Temps de requête : 1.75 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.029 MB mémoire avant requête : 8.097 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.06 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	1.31 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.01 ms
   executing	0.15 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 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
   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]

   ---

9. Temps de requête : 2.92 ms Après la dernière requête : 2.36 ms Mémoire de requête : 0.121 MB mémoire avant requête : 8.373 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.07 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	1.89 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.11 ms
   preparing	0.03 ms
   executing	0.54 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.09 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]

   ---

10. Temps de requête : 2.06 ms Après la dernière requête : 1.00 ms Mémoire de requête : 0.006 MB mémoire avant requête : 8.489 MB

    UPDATE `jhkos_extensions`
    
      SET `params` = '{\"mediaversion\":\"ae48cf5f63662ab665ec93824894c5de\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	1.33 ms
    init	0.01 ms
    System lock	0.12 ms
    updating	0.10 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.34 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
    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]

    ---

11. Temps de requête : 2.01 ms Après la dernière requête : 24.28 ms Mémoire de requête : 0.025 MB mémoire avant requête : 11.677 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.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	1.51 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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:101
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1140
    11	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1268
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

12. Temps de requête : 0.21 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.026 MB mémoire avant requête : 11.713 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.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
    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.01 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/models/shoppergroup.php:50
    16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:109
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1140
    11	VirtueMartModelProduct::getCurrentUserShopperGrps()	JROOT/administrator/components/com_virtuemart/models/product.php:1268
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

13. Temps de requête : 3.13 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.041 MB mémoire avant requête : 11.740 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` = "123"

    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	2.64 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.13 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.16 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/joomla/database/driver.php:1465
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1768
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

14. Temps de requête : 1.06 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.808 MB Rangées retournées : 1

    SELECT `virtuemart_media_id` 
      FROM `jhkos_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "123"  
      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.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.77 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 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.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:1550
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1801
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

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

    SELECT * 
      FROM `jhkos_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "123"  
      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` <= "2026-06-09 05:59:57" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-06-09 05:59:57" ) ) 
      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.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.96 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.07 ms
    end	0.00 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1577
    13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1601
    12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1831
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

16. Temps de requête : 0.98 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.828 MB Rangées retournées : 1

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

    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.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.71 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.03 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:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2174
    13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:2151
    12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1852
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

17. Temps de requête : 2.29 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.025 MB mémoire avant requête : 11.891 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` = "39"

    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.89 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.11 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.08 ms
    freeing items	0.05 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/product.php:2155
    12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1852
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1293
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

18. Temps de requête : 3.12 ms Après la dernière requête : 2.40 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.159 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 (123) 
      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.11 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	2.59 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 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.10 ms
    freeing items	0.04 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:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:163
    11	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1424
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

19. Temps de requête : 2.75 ms Après la dernière requête : 3.02 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.641 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.14 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.20 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.12 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.10 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:1662
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:316
    16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
    15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
    14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

20. Temps de requête : 0.22 ms Après la dernière requête : 0.63 ms Mémoire de requête : 0.025 MB mémoire avant requête : 12.794 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.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
    optimizing	0.01 ms
    statistics	0.03 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.00 ms
    freeing items	0.02 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:1465
    17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
    16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1161
    15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
    14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

21. Temps de requête : 2.27 ms Après la dernière requête : 4.12 ms Mémoire de requête : 0.036 MB mémoire avant requête : 13.415 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.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.68 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.51 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 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.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 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.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.01 ms
    checking permissions	0.01 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.03 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    25	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:787
    24	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
    23	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:239
    22	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:441
    21	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:403
    20	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:620
    19	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
    18	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:572
    17	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:381
    16	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
    15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

22. Temps de requête : 1.29 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.038 MB mémoire avant requête : 13.457 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.77 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.10 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.09 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/administrator/components/com_virtuemart/helpers/vmmodel.php:515
    19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
    18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:441
    17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
    16	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
    15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

23. Temps de requête : 0.38 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.034 MB mémoire avant requête : 13.610 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.11 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/administrator/components/com_virtuemart/helpers/vmmodel.php:515
    19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
    18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:447
    17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
    16	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
    15	VirtueMartCart::getCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:250
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:94
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

24. Temps de requête : 2.52 ms Après la dernière requête : 0.62 ms Mémoire de requête : 0.024 MB mémoire avant requête : 13.752 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 <= "2026-06-09 05:59:57" )
    				
      AND (  ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00")  OR publish_down >= "2026-06-09 05:59:57" )
     
      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	1.96 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.19 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.09 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:1506
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:174
    14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:95
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3297
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1438
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php: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]

    ---

25. Temps de requête : 1.48 ms Après la dernière requête : 1.11 ms Mémoire de requête : 0.024 MB mémoire avant requête : 13.959 MB Rangées retournées : 1

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

    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.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	1.17 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 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.07 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]

    ---

26. Temps de requête : 1.39 ms Après la dernière requête : 4.44 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.505 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 (39)  
      AND 
      ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND 
      p.`published`="1" ) 
      AND p.`virtuemart_product_id`!="123" 
     
      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	4	100.00	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.09 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	0.72 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.24 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.11 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
    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]

    ---

27. Temps de requête : 0.48 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.513 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 (39)  
      AND 
      ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND 
      p.`published`="1" ) 
      AND p.`virtuemart_product_id`!="123" 
    
      AND p.`virtuemart_product_id`!="122" 
      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	4	100.00	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.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.02 ms
    Creating tmp table	0.02 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.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]

    ---

28. Temps de requête : 1.10 ms Après la dernière requête : 1.94 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.912 MB Rangées retournées : 1

    SELECT `virtuemart_media_id` 
      FROM `jhkos_virtuemart_category_medias` 
      WHERE `virtuemart_category_id` = "39"  
      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.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.76 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
    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]

    ---

29. Temps de requête : 0.23 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.024 MB mémoire avant requête : 14.919 MB Rangées retournées : 1

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

    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.03 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.06 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]

    ---

30. Temps de requête : 3.51 ms Après la dernière requête : 10.53 ms Mémoire de requête : 0.024 MB mémoire avant requête : 15.903 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.11 ms
    Executing hook on transaction	0.00 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	2.92 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Creating tmp table	0.06 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.08 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()	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]

    ---

31. Temps de requête : 0.47 ms Après la dernière requête : 4.84 ms Mémoire de requête : 0.045 MB mémoire avant requête : 16.515 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` = "124"

    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.06 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.06 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]

    ---

32. Temps de requête : 0.24 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.045 MB mémoire avant requête : 16.530 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` = "122"

    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.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 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.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]

    ---

33. Temps de requête : 1.32 ms Après la dernière requête : 1.96 ms Mémoire de requête : 0.026 MB mémoire avant requête : 16.597 MB Rangées retournées : 0

    SELECT * 
      FROM `jhkos_virtuemart_ratings` 
      WHERE `virtuemart_product_id` = "123" 
      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.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.94 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.04 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]

    ---