walden pond

Récepteur Radio Delta Dore 5610 - Réf 6351400

69,00 € l'unité

–

Récepteur Radio Delta Dore 5610 - Réf 6351400

Commande un éclairage en marche/arrêt et/ou à partir d'un ou plusieurs interrupteurs radio ou télécommandes
Fonction télérupteur ou va-et-vient : possibilité d'associer à plus de 2 points de commande radio (ex : 2 Tyxia 2310)
Eclairage sur détection :
associé avec un détecteur d'ouverture radio, il commande l'éclairage d'un dressing ou d'un cellier à l'ouverture d'une porte
associé à un détecteur de mouvement, il déclenche l'éclairage d'une pièce
Fonction report d'alarme : associé à un système d'alarme Delta Dore compatible, l'éclairage s'allume brièvement pour indiquer la mise en/hors surveillance
Compatible avec la box maison connectée Delta Dore pour un pilotage à distance via un smartphone, une tablette ou un assistant vocal

Facebook

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1653190840,
                "last": 1653190840,
                "now": 1653190840
            },
            "token": "vJpKrhwMaPRhNRxnqgywMTARxUJZAXgb"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": "73"
            }
        },
        "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
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 28.20 ms / 28.20 ms Mémoire: 1.981 MB / 2.33 MB Application: afterLoad

Temps: 191.41 ms / 219.60 ms Mémoire: 8.488 MB / 10.82 MB Application: afterInitialise

Temps: 53.19 ms / 272.79 ms Mémoire: 2.851 MB / 13.67 MB Application: Before Access::preloadComponents (all components)

Temps: 2.54 ms / 275.34 ms Mémoire: 0.068 MB / 13.74 MB Application: After Access::preloadComponents (all components)

Temps: 0.04 ms / 275.37 ms Mémoire: -0.003 MB / 13.74 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Temps: 1.19 ms / 276.56 ms Mémoire: 0.052 MB / 13.79 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Temps: 16.47 ms / 293.03 ms Mémoire: 0.364 MB / 14.15 MB Application: afterRoute

Temps: 1.37 ms / 294.40 ms Mémoire: 0.005 MB / 14.16 MB Application: beforeRenderComponent com_hikashop

Temps: 557.49 ms / 851.90 ms Mémoire: 9.612 MB / 23.77 MB Application: beforeRenderModule mod_hikashop (Related products)

Temps: 20.13 ms / 872.03 ms Mémoire: 0.447 MB / 24.22 MB Application: afterRenderModule mod_hikashop (Related products)

Temps: 0.14 ms / 872.17 ms Mémoire: -0.148 MB / 24.07 MB Application: afterRenderComponent com_hikashop

Temps: 7.68 ms / 879.84 ms Mémoire: 0.156 MB / 24.23 MB Application: afterDispatch

Temps: 80.26 ms / 960.10 ms Mémoire: 0.703 MB / 24.93 MB Application: beforeRenderModule mod_footer (Footer)

Temps: 2.47 ms / 962.57 ms Mémoire: 0.008 MB / 24.94 MB Application: afterRenderModule mod_footer (Footer)

Temps: 0.12 ms / 962.69 ms Mémoire: 0.001 MB / 24.94 MB Application: beforeRenderModule mod_hikashop (Categories on 2 levels)

Temps: 13.08 ms / 975.77 ms Mémoire: 0.156 MB / 25.09 MB Application: afterRenderModule mod_hikashop (Categories on 2 levels)

Temps: 0.08 ms / 975.85 ms Mémoire: -0.003 MB / 25.09 MB Application: beforeRenderModule mod_rssocial (Réseaux Sociaux)

Temps: 8.41 ms / 984.25 ms Mémoire: 0.075 MB / 25.17 MB Application: afterRenderModule mod_rssocial (Réseaux Sociaux)

Temps: 0.05 ms / 984.30 ms Mémoire: -0.046 MB / 25.12 MB Application: beforeRenderModule mod_my_facebook_page (My Facebook Page)

Temps: 1.41 ms / 985.71 ms Mémoire: 0.009 MB / 25.13 MB Application: afterRenderModule mod_my_facebook_page (My Facebook Page)

Temps: 0.03 ms / 985.74 ms Mémoire: -0.004 MB / 25.12 MB Application: beforeRenderModule mod_articles_archive (Archived Articles)

Temps: 5.66 ms / 991.41 ms Mémoire: 0.104 MB / 25.23 MB Application: afterRenderModule mod_articles_archive (Archived Articles)

Temps: 0.08 ms / 991.49 ms Mémoire: -0.001 MB / 25.23 MB Application: beforeRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 3.25 ms / 994.74 ms Mémoire: 0.025 MB / 25.25 MB Application: afterRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 0.09 ms / 994.83 ms Mémoire: -0.004 MB / 25.25 MB Application: beforeRenderModule mod_custom (Image)

Temps: 13.69 ms / 1008.51 ms Mémoire: 0.157 MB / 25.41 MB Application: afterRenderModule mod_custom (Image)

Temps: 0.16 ms / 1008.68 ms Mémoire: 0.004 MB / 25.41 MB Application: beforeRenderModule mod_menu (Menu principal)

Temps: 15.20 ms / 1023.88 ms Mémoire: 0.276 MB / 25.68 MB Application: afterRenderModule mod_menu (Menu principal)

Temps: 0.10 ms / 1023.98 ms Mémoire: -0.014 MB / 25.67 MB Application: beforeRenderModule mod_search (Recherche)

Temps: 2.58 ms / 1026.56 ms Mémoire: 0.017 MB / 25.69 MB Application: afterRenderModule mod_search (Recherche)

Temps: 12.76 ms / 1039.33 ms Mémoire: 0.214 MB / 25.90 MB Application: afterRender

Total de requêtes base de données : 531.58 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_session	const	PRIMARY	PRIMARY	194	const	1

#	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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	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

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

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.01 ms
Update	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	15.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de requête : 2.63 ms Après la dernière requête : 3.61 ms Mémoire de requête : 0.056 MB mémoire avant requête : 4.380 MB Rangées retournées : 46

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

  FROM `uf842_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_extensions	ref	extension	extension	82	const	47	Using index condition; Using where

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.89 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.64 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id, rules

  FROM `uf842_viewlevels`

Explication

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

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.78 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.18 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.692 MB Rangées retournées : 2

SELECT b.id

  FROM uf842_usergroups AS a

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

  WHERE a.id = 9

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.42 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.05 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.051 MB mémoire avant requête : 4.762 MB Rangées retournées : 144

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

  FROM uf842_extensions

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

  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_extensions	ref	extension	extension	82	const	240	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.17 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `uf842_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
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/k2/k2.php:47
8	plgSystemK2->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 21.31 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.006 MB mémoire avant requête : 10.271 MB

UPDATE `uf842_extensions`

  SET `params` = '{\"mediaversion\":\"9039dd441468342a4aa00bcd36e01d0b\"}'

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.06 ms
Updating	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	20.73 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.02 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/k2/k2.php:47
8	plgSystemK2->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 23.70 ms Après la dernière requête : 8.53 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.629 MB Rangées retournées : 1

SELECT `template`

  FROM `uf842_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_template_styles	ALL	idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	Using where

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	22.87 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:240
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:38
8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.84 ms Après la dernière requête : 5.60 ms Mémoire de requête : 0.048 MB mémoire avant requête : 11.099 MB Rangées retournées : 21

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM uf842_menu AS m

  LEFT JOIN uf842_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	28	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	avsdo1420748.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.61 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.41 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.87 ms Après la dernière requête : 41.50 ms Mémoire de requête : 0.046 MB mémoire avant requête : 13.377 MB Rangées retournées : 289

SELECT * 
  FROM uf842_hikashop_config

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_hikashop_config	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	289

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.56 ms
After opening tables	0.05 ms
System lock	0.02 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.37 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.04 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	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_hikashop/classes/config.php:16
14	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1183
13	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3103
12	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:163
11	_HikashopParseRoute()	JROOT/components/com_hikashop/router.php:152
10	HikashopParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.22 ms Après la dernière requête : 4.98 ms Mémoire de requête : 0.027 MB mémoire avant requête : 13.681 MB Rangées retournées : 46

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

  FROM `uf842_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyfrontendseo','com_fields','com_finder','com_hikashop','com_installer','com_jce','com_jmap','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilemenuck','com_modules','com_newsfeeds','com_osmap','com_phocapdf','com_plugins','com_pollmanager','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_tcpdf','com_templateck','com_templates','com_users','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_assets	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	145	Using where

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.02 ms
Opening tables	1.00 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.02 ms
Statistics	0.14 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.28 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.16 ms Après la dernière requête : 8.38 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.012 MB Rangées retournées : 2

SELECT *

  FROM uf842_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_languages	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.53 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:235
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id, home, template, s.params

  FROM uf842_template_styles as s

  LEFT JOIN uf842_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	avsdo1420748.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	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/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:259
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 208.14 ms Après la dernière requête : 16.90 ms Mémoire de requête : 0.041 MB mémoire avant requête : 14.815 MB Rangées retournées : 1

SELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering  
  FROM uf842_hikashop_product AS product  
  LEFT JOIN uf842_hikashop_product_category AS product_category 
  ON product.product_id = product_category.product_id  
  WHERE (product.product_id = 2) 
  LIMIT 0, 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	product	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	product_category	ref	product_id	product_id	4	const	1

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	1.16 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_hikashop/views/product/view.html.php:1153
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM uf842_modules 
  WHERE id IN (149,0) 
  AND language IN ('*', '', 'fr-FR')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_modules	range	PRIMARY,idx_language	PRIMARY	4	NULL	2	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	60.50 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.34 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.25 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.11 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/helpers/module.php:123
14	hikashopModuleHelper->setModuleData()	JROOT/components/com_hikashop/views/product/view.html.php:1158
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #44

SELECT cart.cart_id 
  FROM uf842_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = '5e72c0d720546324d6faafb55df153db')  
  ORDER BY cart.cart_current DESC, cart.cart_modified DESC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.69 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
16	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:139
15	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:401
14	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:1199
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM uf842_hikashop_currency 
  WHERE currency_id IN (1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_hikashop_currency	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	3.79 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	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_hikashop/classes/currency.php:1874
14	hikashopCurrencyClass->getCurrencies()	JROOT/components/com_hikashop/views/product/view.html.php:1202
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.72 ms Après la dernière requête : 47.19 ms Mémoire de requête : 0.007 MB mémoire avant requête : 20.109 MB

UPDATE uf842_hikashop_product 
  SET product_hit = product_hit + 1, product_last_seen_date = 1653190841 
  WHERE product_id = 2

Explication

EXPLAIN impossible sur la requête : UPDATE uf842_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1653190841 WHERE product_id = 2

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.04 ms
Updating	0.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_hikashop/classes/product.php:4106
14	hikashopProductClass->hit()	JROOT/components/com_hikashop/views/product/view.html.php:1242
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.*  
  FROM uf842_hikashop_product_related AS pr  
  LEFT JOIN uf842_hikashop_product AS p 
  ON pr.product_related_id = p.product_id  
  WHERE (pr.product_id = 2) 
  AND (pr.product_related_type = 'options') 
  AND (p.product_published = 1) 
  AND ((p.product_sale_start = '' OR p.product_sale_start <= 1653190841)) 
  AND ((p.product_sale_end = '' OR p.product_sale_end > 1653190841))  
  ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	2.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1264
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM uf842_hikashop_product 
  WHERE (product_parent_id IN (2)) 
  AND (product_published = 1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_hikashop_product	ref	product_parent_id	product_parent_id	4	const	1	Using where

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1309
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT v.*, c.*  
  FROM uf842_hikashop_variant AS v  
  INNER JOIN uf842_hikashop_characteristic AS c 
  ON v.variant_characteristic_id = c.characteristic_id  
  WHERE v.variant_product_id IN (2)  
  ORDER BY v.ordering ASC, c.characteristic_ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	7.19 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1350
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM uf842_hikashop_file 
  WHERE file_ref_id IN (2) 
  AND file_type IN ('product','file') 
  ORDER BY file_ordering ASC, file_id ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_hikashop_file	ALL	file_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	3.25 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1395
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.82 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.024 MB mémoire avant requête : 20.147 MB Rangées retournées : 2

SELECT currency_id 
  FROM uf842_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_hikashop_currency	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	182	Using where

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:471
16	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:1555
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1517
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1401
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.* 
  FROM uf842_hikashop_price as p 
  WHERE (p.price_currency_id IN (1,2)) 
  AND (p.price_start_date < 1653190841) 
  AND ((p.price_end_date < 1 OR p.price_end_date > 1653190841)) 
  AND (p.price_product_id IN (2)) 
  AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) 
  ORDER BY p.price_site_id ASC, p.price_value DESC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ref	price_product_id	price_product_id	4	const	1	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	1.88 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1599
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1517
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1401
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.*,c.* 
  FROM uf842_hikashop_category AS a 
  LEFT JOIN uf842_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN uf842_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey 
  WHERE a.category_id = 11 
  AND b.taxation_published=1 
  AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
  AND b.taxation_date_start <= 1653190841 
  AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1653190841) 
  ORDER BY b.taxation_id ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	b	system	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1
1	SIMPLE	a	const	PRIMARY,category_namekey	PRIMARY	4	const	1
1	SIMPLE	c	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	3.73 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	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_hikashop/classes/currency.php:197
19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2651
17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1691
16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1609
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1517
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1401
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM uf842_hikashop_zone 
  WHERE zone_id = 73

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_hikashop_zone	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	4.27 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	2.31 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/currency.php:218
19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2651
17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1691
16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1609
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1517
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1401
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM uf842_hikashop_discount 
  WHERE (discount_type = 'discount') 
  AND (discount_published = 1) 
  AND (discount_quota > discount_used_times OR discount_quota = 0) 
  AND (discount_start < 1653190841) 
  AND (discount_end > 1653190841 OR discount_end = 0) 
  AND (discount_product_id IN ('','0','2') OR discount_product_id LIKE '%,2,%') 
  AND (discount_flat_amount != 0 OR discount_percent_amount != 0) 
  AND ((discount_flat_amount = 0 OR discount_currency_id =1)) 
  AND ((discount_user_id = '' OR discount_user_id LIKE '%,0,%'))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.02 ms
Opening tables	2.75 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1659
15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1517
14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1401
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT category_id 
  FROM uf842_hikashop_product_category 
  WHERE product_id IN (2) 
  ORDER BY ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_hikashop_product_category	ref	product_id	product_id	4	const	1	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/product.php:1181
16	hikashopProductClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:303
15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:188
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1404
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 6.58 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.026 MB mémoire avant requête : 21.041 MB Rangées retournées : 2

SELECT hk_parent.* 
  FROM uf842_hikashop_category AS hk_cat  
  LEFT JOIN uf842_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)  
  WHERE  hk_cat.category_id IN (2)  
  GROUP BY hk_parent.category_id  
  ORDER BY hk_parent.category_left

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hk_cat	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	hk_parent	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.11 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	5.12 ms
Creating sort index	0.10 ms
Removing tmp table	0.26 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:761
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:308
15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:188
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1404
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM uf842_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='product'  
  AND ((((field_with_sub_categories = 0 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories = 1 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) 
  AND field_products="") OR (field_products LIKE '%,2,%')) 
  ORDER BY a.`field_ordering` ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	15	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.40 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:167
15	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:189
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1404
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.* 
  FROM uf842_hikashop_badge AS a 
  WHERE a.badge_start <= 1653190841 
  AND (a.badge_end >= 1653190841 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 8412398) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	9.01 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
14	hikashopBadgeClass->loadBadges()	JROOT/components/com_hikashop/views/product/view.html.php:1546
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.*  
  FROM uf842_hikashop_product_category AS a  
  LEFT JOIN uf842_hikashop_category AS b 
  ON a.category_id = b.category_id  
  WHERE a.product_id = 2 
  ORDER BY a.product_category_id ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	product_id	product_id	4	const	1	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	avsdo1420748.a.category_id	1

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1716
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.id 
  FROM uf842_menu AS a 
  INNER JOIN `uf842_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' 
  AND a.language IN ('*', '', 'fr-FR')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	avsdo1420748.b.menutype	8	Using where

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	33.14 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.22 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.22 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:197
15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:1751
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.95 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.024 MB mémoire avant requête : 21.661 MB Rangées retournées : 5

SELECT a.id 
  FROM uf842_menu AS a 
  INNER JOIN `uf842_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link LIKE 'index.php?option=com_hikashop&view=%' 
  AND a.language IN ('*', '', 'fr-FR')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	avsdo1420748.b.menutype	8	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.20 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:201
15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:1751
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 9.17 ms Après la dernière requête : 9.52 ms Mémoire de requête : 0.026 MB mémoire avant requête : 22.232 MB Rangées retournées : 0

SELECT a.*, c.currency_symbol 
  FROM uf842_hikashop_shipping AS a  
  INNER JOIN uf842_hikashop_currency AS c 
  ON c.currency_id = a.shipping_currency_id  
  WHERE (a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' OR a.shipping_params LIKE '%s:20:\"shipping_per_product\";i:1%') 
  ORDER BY a.shipping_id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	8.23 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:45
18	plgHikashopShippingmanual_prices->_getShippings()	JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:324
17	plgHikashopShippingmanual_prices->onHikashopBeforeDisplayView()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2432
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM uf842_extensions 
  WHERE folder='hikashop' 
  AND element='shippingmanual_prices' 
  AND type='plugin'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.07 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
18	hikashopPluginsClass->getByName()	JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:328
17	plgHikashopShippingmanual_prices->onHikashopBeforeDisplayView()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2432
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.95 ms Après la dernière requête : 4.81 ms Mémoire de requête : 0.029 MB mémoire avant requête : 22.530 MB Rangées retournées : 1

SELECT * 
  FROM uf842_extensions 
  WHERE folder='system' 
  AND element='hikashopsocial' 
  AND type='plugin'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
24	hikashopPluginsClass->getByName()	JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php:12
23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:45
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:97
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.77 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.028 MB mémoire avant requête : 22.544 MB Rangées retournées : 0

SELECT * 
  FROM uf842_extensions 
  WHERE folder='content' 
  AND element='hikashopsocial' 
  AND type='plugin'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
24	hikashopPluginsClass->getByName()	JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php:16
23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:45
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:97
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.48 ms Après la dernière requête : 19.28 ms Mémoire de requête : 0.029 MB mémoire avant requête : 22.996 MB Rangées retournées : 0

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

  FROM `uf842_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_hikashop.product' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	avsdo1420748.m.tag_id	1	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	1.34 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.19 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
24	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_hikashop/views/product/tmpl/show_block_tags.php:29
23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_tags.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:218
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:97
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.64 ms Après la dernière requête : 6.55 ms Mémoire de requête : 0.014 MB mémoire avant requête : 23.224 MB

CREATE TABLE IF NOT EXISTS `uf842_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Explication

EXPLAIN impossible sur la requête : CREATE TABLE IF NOT EXISTS `uf842_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.07 ms
After create	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Commit_implicit	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
30	JDatabase->query()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:116
29	PowrHelper->get_powr_token()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:93
28	PowrHelper->__construct()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:163
27	require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
26	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
25	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
24	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
23	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
22	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
21	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:237
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:97
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT value 
  FROM uf842_powr 
  WHERE data_type = 'powr_token'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_powr	const	PRIMARY	PRIMARY	152	const	1

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.39 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
30	JDatabaseDriver->loadAssoc()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:121
29	PowrHelper->get_powr_token()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:93
28	PowrHelper->__construct()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:163
27	require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
26	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
25	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
24	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
23	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
22	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
21	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:237
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:97
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.80 ms Après la dernière requête : 17.10 ms Mémoire de requête : 0.028 MB mémoire avant requête : 24.009 MB Rangées retournées : 0

Requêtes dupliquées: #18

SELECT cart.cart_id 
  FROM uf842_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = '5e72c0d720546324d6faafb55df153db')  
  ORDER BY cart.cart_current DESC, cart.cart_modified DESC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
25	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:139
24	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:401
23	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:463
22	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
21	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:755
20	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
19	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_hikashop/views/product/tmpl/show.php:418
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.11 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.029 MB mémoire avant requête : 24.022 MB Rangées retournées : 1

SELECT a.*,b.* 
  FROM uf842_hikashop_category AS a 
  LEFT JOIN uf842_hikashop_file AS b 
  ON a.category_id = b.file_ref_id 
  AND b.file_type = 'category' 
  WHERE a.category_id = 2 
  LIMIT 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	ref	file_type	file_type	767	const	1	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.07 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/category.php:35
23	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:523
22	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
21	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:755
20	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
19	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_hikashop/views/product/tmpl/show.php:418
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.20 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.029 MB mémoire avant requête : 24.039 MB Rangées retournées : 0

SELECT DISTINCT b.* 
  FROM uf842_hikashop_product_related AS a 
  LEFT JOIN uf842_hikashop_product AS b 
  ON a.product_related_id=b.product_id 
  WHERE (b.product_published = 1) 
  AND (a.product_related_type='related') 
  AND (a.product_id=2) 
  AND (b.product_type = 'main') 
  ORDER BY a.product_related_ordering ASC 
  LIMIT 0, 21

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.09 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:847
22	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
21	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:755
20	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
19	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_hikashop/views/product/tmpl/show.php:418
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.66 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.052 MB Rangées retournées : 1

SELECT COUNT( DISTINCT b.product_id ) 
  FROM uf842_hikashop_product_related AS a 
  LEFT JOIN uf842_hikashop_product AS b 
  ON a.product_related_id=b.product_id 
  WHERE (b.product_published = 1) 
  AND (a.product_related_type='related') 
  AND (a.product_id=2) 
  AND (b.product_type = 'main') 
  ORDER BY a.product_related_ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/components/com_hikashop/views/product/view.html.php:899
22	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
21	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:755
20	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
19	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_hikashop/views/product/tmpl/show.php:418
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.10 ms Après la dernière requête : 8.93 ms Mémoire de requête : 0.028 MB mémoire avant requête : 24.197 MB Rangées retournées : 1

SELECT a.params

  FROM uf842_advancedmodules AS a

  WHERE a.moduleid = 149

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.43 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:421
25	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:375
24	PlgSystemAdvancedModuleHelper->getAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:198
23	PlgSystemAdvancedModuleHelper->setAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:476
22	PlgSystemAdvancedModuleHelper->isEmpty()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:460
21	PlgSystemAdvancedModuleHelper->onRenderModule()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:245
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_hikashop/views/product/tmpl/show.php:418
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2513
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2468
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2198
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1964
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2176
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 21.71 ms Après la dernière requête : 13.59 ms Mémoire de requête : 0.043 MB mémoire avant requête : 24.340 MB Rangées retournées : 20

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

  FROM uf842_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	published,newsfeeds	published	1	const	26	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	avsdo1420748.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	avsdo1420748.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.56 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:168
14	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
13	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:91
7	require JROOT/templates/protostar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 23.06 ms Après la dernière requête : 28.86 ms Mémoire de requête : 0.037 MB mémoire avant requête : 24.896 MB Rangées retournées : 283

SHOW TABLES

Explication

EXPLAIN impossible sur la requête : SHOW TABLES

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Checking permissions	2.30 ms
Executing	0.04 ms
Sending data	0.27 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.07 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/mobilemenuck/helpers/helper.php:182
9	Mobilemenuck\Helper::searchTable()	JROOT/plugins/system/mobilemenuck/helpers/helper.php:170
8	Mobilemenuck\Helper::checkIsProVersion()	JROOT/plugins/system/mobilemenuck/mobilemenuck.php:543
7	PlgSystemMobilemenuck->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM uf842_hikashop_category 
  WHERE category_id = '2' 
  LIMIT 0, 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_hikashop_category	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 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_hikashop/helpers/helper.php:2367
15	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/category.php:37
14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/category/view.html.php:151
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:755
11	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
10	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.* 
  FROM uf842_hikashop_category AS a 
  WHERE a.category_parent_id = 2 
  AND a.category_published=1 
  ORDER BY a.category_ordering ASC 
  LIMIT 0, 21

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	0.09 ms
End of update loop	0.07 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:602
14	hikashopCategoryClass->getChildren()	JROOT/components/com_hikashop/views/category/view.html.php:301
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:755
11	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
10	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT COUNT(*)  
  FROM uf842_hikashop_category AS a 
  WHERE a.category_parent_id = 2 
  AND a.category_published=1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_hikashop/views/category/view.html.php:306
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:755
11	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
10	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.44 ms Après la dernière requête : 14.42 ms Mémoire de requête : 0.022 MB mémoire avant requête : 25.228 MB Rangées retournées : 0

SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year

  FROM uf842_content

  WHERE state = 2

  GROUP BY YEAR(`created`), MONTH(`created`)

  ORDER BY YEAR(`created`) DESC, MONTH(`created`) DESC 
  LIMIT 10

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_content	ref	idx_state	idx_state	1	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	1.20 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.17 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 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/modules/mod_articles_archive/helper.php:51
11	ModArchiveHelper::getList()	JROOT/modules/mod_articles_archive/mod_articles_archive.php:17
10	include JROOT/modules/mod_articles_archive/mod_articles_archive.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 6.49 ms Après la dernière requête : 10.56 ms Mémoire de requête : 0.027 MB mémoire avant requête : 25.411 MB Rangées retournées : 0

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

  FROM uf842_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	avsdo1420748.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	avsdo1420748.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	avsdo1420748.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	avsdo1420748.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	avsdo1420748.a.group_id	1	Using where

Profil

Status	Duration
Starting	0.24 ms
Checking permissions	0.02 ms
Opening tables	2.93 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.10 ms
Optimizing	0.07 ms
Statistics	0.34 ms
Preparing	0.09 ms
Creating tmp table	0.10 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	1.29 ms
Creating sort index	0.09 ms
Removing tmp table	0.39 ms
Creating sort index	0.05 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.18 ms Après la dernière requête : 20.21 ms Mémoire de requête : 0.022 MB mémoire avant requête : 25.739 MB Rangées retournées : 0

SELECT * 
  FROM `uf842_plg_easyfrontendseo` 
  WHERE `url` = 'index.php?option=com_hikashop&ctrl=product&task=show&cid=2&name=recepteur-radio-delta-dore-5610-ref-6351400'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_plg_easyfrontendseo	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.02 ms
Opening tables	1.26 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 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/plugins/system/easyfrontendseo/easyfrontendseo.php:513
12	PlgSystemEasyFrontendSeo->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.91 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.022 MB mémoire avant requête : 25.744 MB Rangées retournées : 0

SELECT *
 
  FROM uf842_jmap_metainfo
 
  WHERE `linkurl` = 'http://www.avs-domotique.fr/component/hikashop/product/2-recepteur-radio-delta-dore-5610-ref-6351400'
 
  AND `published` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_jmap_metainfo	ALL	published	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	24	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.82 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.16 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:514
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *
 
  FROM uf842_jmap_canonicals
 
  WHERE `linkurl` = 'http://www.avs-domotique.fr/component/hikashop/product/2-recepteur-radio-delta-dore-5610-ref-6351400'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uf842_jmap_canonicals	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.75 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.10 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:593
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Récepteur Radio Delta Dore 5610 - Réf 6351400

Récepteur Radio Delta Dore 5610 - Réf 6351400

My Facebook Page

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

59 requêtes exécutées 531.58 ms

2 doubles découverts!