Assemblée Générale 2015

Lillers

14 novembre 2014

Boutique (43)

Bienvenue à la boutique de l'URC

Les adhérents de l'URC ont des avantages :

10% sur les fournitures
Les livres à moitié prix
Lot OCI gratuit
Diplômes gratuits formulaire de demande

Pour bénéficier de ces réductions il faut télécharger le code approprié. Attention un seul code par commande.

Pour télécharger les coupons de réductions, il faut être enregistré sur le site et il faut avoir des droits "adhérents de l'URC" qui sont donnés automatiquement par le webmaster, compter 24h00. Si au bout de ce délai vous n'avez toujours pas accès aux coupons, ou pour tout problème avec votre commande vous pouvez contacter le webmaster : webmaster (at) urc.asso.fr

Lorsque votre commande est enregistrée, vous recevez un email, lorsque le paiement est enregistré, vous recevez un email de confirmation, et lorsque la commande est envoyée vous recevez un email. Il peut se passer un certain temps entre la confirmation et l'envoi, nous essayons de le réduire au minimum, mais nous sommes tous des bénévoles au service de nos adhérents.

Téléchargements (0)

1,00 € l'unité

Décodeur CW Arduino

Le décodeur CW sur base Arduino est le complément idéal du Mini CW.

Téléchargement gratuit pour les adhérents voir le code de réduction

HikaShop , Joomla!™ Online Store Component

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675256153,
                "last": 1675256153,
                "now": 1675256153
            },
            "client": {
                "forwarded": "44.213.63.130"
            },
            "token": "uwp6IHm98Y0FprSgtrynahJPlUPH02Gi"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": ""
            }
        },
        "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

Occupation de la mémoire

Requêtes de base de données

53 requêtes exécutées 69.97 ms

12 doubles découverts!

2 requêtes dupliquées: #15 #16

2 requêtes dupliquées: #23 #31

3 requêtes dupliquées: #26 #28 #29

2 requêtes dupliquées: #30 #38

3 requêtes dupliquées: #48 #49 #50

Temps de requête : 0.92 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.035 MB Rangées retournées : 0

SELECT `data`

  FROM `wm9td_session`

  WHERE `session_id` = X'6539656239636632343361663731336332613065633936343766353133353265'

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

SELECT `session_id`

  FROM `wm9td_session`

  WHERE `session_id` = X'6539656239636632343361663731336332613065633936343766353133353265' 
  LIMIT 1

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 1.83 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.055 MB

INSERT INTO `wm9td_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
(X'6539656239636632343361663731336332613065633936343766353133353265', 1, 1675256153, 0, '')

Explication

EXPLAIN impossible sur la requête : INSERT INTO `wm9td_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'6539656239636632343361663731336332613065633936343766353133353265', 1, 1675256153, 0, '')

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.11 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	1.16 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 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 : 1.65 ms Après la dernière requête : 3.08 ms Mémoire de requête : 0.040 MB mémoire avant requête : 1.086 MB Rangées retournées : 43

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

  FROM `wm9td_extensions`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wm9td_extensions	NULL	ref	extension	extension	82	const	47	1.00	Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.31 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.51 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 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.36 ms Après la dernière requête : 2.76 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.129 MB Rangées retournées : 9

SELECT id, rules

  FROM `wm9td_viewlevels`

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.28 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 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.06 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.143 MB Rangées retournées : 1

SELECT b.id

  FROM wm9td_usergroups AS a

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

  WHERE a.id = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	100.00	Using where; Using index

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 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.40 ms Après la dernière requête : 0.36 ms Mémoire de requête : 0.031 MB mémoire avant requête : 1.164 MB Rangées retournées : 124

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

  FROM wm9td_extensions

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

  ORDER BY ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wm9td_extensions	NULL	ref	extension	extension	82	const	211	0.40	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.48 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.02 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 : 5.02 ms Après la dernière requête : 29.64 ms Mémoire de requête : 0.218 MB mémoire avant requête : 1.738 MB Rangées retournées : 111

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

  LEFT JOIN wm9td_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	169	10.00	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	urchtszt001.m.component_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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 : 0.93 ms Après la dernière requête : 20.31 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.341 MB Rangées retournées : 1

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

  FROM `wm9td_extensions`

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.95 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.005 MB mémoire avant requête : 2.331 MB

UPDATE `wm9td_extensions`

  SET `params` = '{\"mediaversion\":\"7af1551c25bc3f74a6c7d3ccb90aaa03\"}'

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	wm9td_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.11 ms
updating	0.15 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	1.05 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.17 ms Après la dernière requête : 1.03 ms Mémoire de requête : 0.020 MB mémoire avant requête : 2.414 MB Rangées retournées : 2

SELECT *

  FROM wm9td_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.31 ms
init	0.04 ms
System lock	0.01 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.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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.46 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.019 MB mémoire avant requête : 2.435 MB Rangées retournées : 5

SELECT id, home, template, s.params

  FROM wm9td_template_styles as s

  LEFT JOIN wm9td_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	9	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	urchtszt001.e.element	1	66.67	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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.80 ms Après la dernière requête : 12.05 ms Mémoire de requête : 0.096 MB mémoire avant requête : 3.152 MB Rangées retournées : 345

SELECT * 
  FROM wm9td_hikashop_config

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.65 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 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/administrator/components/com_hikashop/classes/config.php:16
9	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1232
8	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3206
7	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/hikashop.php:16
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.15 ms Après la dernière requête : 8.37 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.743 MB Rangées retournées : 1

SELECT * 
  FROM wm9td_menu 
  WHERE id = '1615' 
  LIMIT 0, 1

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
17	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/menus.php:20
16	hikashopMenusClass->get()	JROOT/administrator/components/com_hikashop/helpers/module.php:233
15	hikashopModuleHelper->_getParams()	JROOT/administrator/components/com_hikashop/helpers/module.php:14
14	hikashopModuleHelper->initialize()	JROOT/components/com_hikashop/views/category/view.html.php:37
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.09 ms Après la dernière requête : 1.86 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.983 MB Rangées retournées : 1

Requêtes dupliquées: #16

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
15	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/category.php:37
14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/category/view.html.php:84
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.025 MB mémoire avant requête : 3.993 MB Rangées retournées : 1

Requêtes dupliquées: #15

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
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/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.07 ms Après la dernière requête : 27.90 ms Mémoire de requête : 0.026 MB mémoire avant requête : 7.172 MB Rangées retournées : 3

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

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 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.03 ms
Creating sort index	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:612
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/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.024 MB mémoire avant requête : 7.188 MB Rangées retournées : 3

SELECT * 
  FROM wm9td_hikashop_file 
  WHERE file_type='category' 
  AND file_ref_id IN (16,17,21)

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.17 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:632
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/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.65 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.199 MB Rangées retournées : 1

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.78 ms Après la dernière requête : 2.13 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.357 MB Rangées retournées : 3

SELECT category_left,category_right 
  FROM wm9td_hikashop_category 
  WHERE category_id IN (16,17,21)

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wm9td_hikashop_category	NULL	range	PRIMARY	PRIMARY	4	NULL	3	100.00	Using index condition

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:516
14	hikashopCategoryClass->getChildren()	JROOT/components/com_hikashop/views/category/view.html.php:333
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.15 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.028 MB mémoire avant requête : 7.368 MB Rangées retournées : 10

SELECT a.* 
  FROM wm9td_hikashop_category AS a 
  WHERE ((a.category_left > 3 
  AND a.category_right < 10) OR (a.category_left > 11 
  AND a.category_right < 28) OR (a.category_left > 29 
  AND a.category_right < 30)) 
  AND a.category_published=1 
  ORDER BY a.category_ordering ASC

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 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.43 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:612
14	hikashopCategoryClass->getChildren()	JROOT/components/com_hikashop/views/category/view.html.php:333
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.27 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.400 MB Rangées retournées : 7

SELECT count(pc.product_id) AS number_of_products, pc.category_id  
  FROM wm9td_hikashop_product_category AS pc  
  INNER JOIN wm9td_hikashop_product AS p 
  ON pc.product_id = p.product_id 
  AND p.product_published > 0 
  AND p.product_parent_id = 0  
  WHERE pc.category_id IN (16,17,21,23,13,20,14,22,15,19,24,25,26) 
  GROUP BY pc.category_id

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pc	NULL	range	category_id	category_id	4	NULL	55	100.00	Using where; Using index
1	SIMPLE	p	NULL	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	urchtszt001.pc.product_id	1	20.88	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/category/view.html.php:366
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.92 ms Après la dernière requête : 2.02 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.665 MB Rangées retournées : 1

Requêtes dupliquées: #31

SELECT a.*,b.* 
  FROM wm9td_hikashop_category AS a 
  LEFT JOIN wm9td_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	74	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/category.php:35
14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/category/view.html.php:384
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.43 ms Après la dernière requête : 4.27 ms Mémoire de requête : 0.026 MB mémoire avant requête : 8.423 MB Rangées retournées : 2

SELECT hk_parent.* 
  FROM wm9td_hikashop_category AS hk_cat  
  LEFT JOIN wm9td_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 = 2 
  GROUP BY hk_parent.category_id  
  ORDER BY hk_parent.category_left

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.24 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 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:771
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:495
15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:188
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/category/view.html.php:388
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.92 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.025 MB mémoire avant requête : 8.437 MB Rangées retournées : 0

SELECT * 
  FROM wm9td_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='category'  
  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,%'))) 
  ORDER BY a.`field_ordering` ASC

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 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.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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/category/view.html.php:388
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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 : 3.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.524 MB Rangées retournées : 0

Requêtes dupliquées: #28 #29

SELECT a.id as itemid 
  FROM `wm9td_menu` as a 
  WHERE a.client_id=0 
  AND a.parent_id=1615

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/category/view.html.php:498
14	CategoryViewCategory->getLink()	JROOT/components/com_hikashop/views/category/view.html.php:469
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.00 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.024 MB mémoire avant requête : 8.534 MB Rangées retournées : 1

SELECT a.id 
  FROM wm9td_menu AS a 
  INNER JOIN `wm9td_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) 
  AND a.client_id=0 
  AND a.link='index.php?option=com_hikashop&view=category&layout=listing' 
  AND a.language IN ('*', '', 'fr-FR')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_client_id_parent_id_alias_language	1	const	170	0.42	Using index condition; Using where
1	SIMPLE	b	NULL	eq_ref	idx_menutype	idx_menutype	98	urchtszt001.a.menutype	1	75.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	1.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	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:323
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1121
15	hikashop_contentLink()	JROOT/components/com_hikashop/views/category/view.html.php:554
14	CategoryViewCategory->getLink()	JROOT/components/com_hikashop/views/category/view.html.php:469
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.54 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.542 MB Rangées retournées : 0

Requêtes dupliquées: #26 #29

SELECT a.id as itemid 
  FROM `wm9td_menu` as a 
  WHERE a.client_id=0 
  AND a.parent_id=1615

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/category/view.html.php:498
14	CategoryViewCategory->getLink()	JROOT/components/com_hikashop/views/category/view.html.php:469
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.54 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.550 MB Rangées retournées : 0

Requêtes dupliquées: #26 #28

SELECT a.id as itemid 
  FROM `wm9td_menu` as a 
  WHERE a.client_id=0 
  AND a.parent_id=1615

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/category/view.html.php:498
14	CategoryViewCategory->getLink()	JROOT/components/com_hikashop/views/category/view.html.php:469
13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:25
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.34 ms Après la dernière requête : 95.58 ms Mémoire de requête : 0.027 MB mémoire avant requête : 10.567 MB Rangées retournées : 0

Requêtes dupliquées: #38

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:69
23	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:165
22	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:405
21	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:465
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.27 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.579 MB Rangées retournées : 1

Requêtes dupliquées: #23

SELECT a.*,b.* 
  FROM wm9td_hikashop_category AS a 
  LEFT JOIN wm9td_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	74	100.00	Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.31 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/category.php:35
21	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:525
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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 : 0.90 ms Mémoire de requête : 0.027 MB mémoire avant requête : 10.653 MB Rangées retournées : 0

SELECT a.id 
  FROM wm9td_menu AS a 
  INNER JOIN `wm9td_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) 
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_client_id_parent_id_alias_language	1	const	170	0.42	Using index condition; Using where
1	SIMPLE	b	NULL	eq_ref	idx_menutype	idx_menutype	98	urchtszt001.a.menutype	1	75.00	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	1.31 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:323
23	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:236
22	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
21	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:732
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.09 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.671 MB Rangées retournées : 1

SELECT a.id 
  FROM wm9td_menu AS a 
  INNER JOIN `wm9td_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) 
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_client_id_parent_id_alias_language	1	const	170	0.42	Using index condition; Using where
1	SIMPLE	b	NULL	eq_ref	idx_menutype	idx_menutype	98	urchtszt001.a.menutype	1	75.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:323
23	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:241
22	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
21	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:732
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.28 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.029 MB mémoire avant requête : 10.686 MB Rangées retournées : 1

SELECT DISTINCT b.* 
  FROM wm9td_hikashop_product_category AS a 
  LEFT JOIN wm9td_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE (b.product_published = 1) 
  AND (b.product_type = 'main') 
  AND (a.category_id IN (2)) 
  ORDER BY a.ordering ASC 
  LIMIT 0, 4

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	category_id	category_id	4	const	1	100.00	Using index condition; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	4	urchtszt001.a.product_id	1	5.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.13 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.77 ms
Creating sort index	0.11 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.06 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:849
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.94 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.027 MB mémoire avant requête : 10.704 MB Rangées retournées : 2

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

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.05 ms
System lock	0.01 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.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:2398
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.31 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.718 MB Rangées retournées : 0

SELECT variant_product_id 
  FROM wm9td_hikashop_variant 
  WHERE variant_product_id IN (100)

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wm9td_hikashop_variant	NULL	index	NULL	PRIMARY	8	NULL	61	10.00	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:2422
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.52 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.729 MB Rangées retournées : 0

SELECT product_id 
  FROM wm9td_hikashop_product_related 
  WHERE product_related_type = 'options' 
  AND product_id IN (100)

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:2438
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.58 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.743 MB Rangées retournées : 0

Requêtes dupliquées: #30

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:69
26	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:165
25	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:405
24	hikashop_getZone()	JROOT/administrator/components/com_hikashop/classes/currency.php:485
23	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:478
22	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:2453
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.07 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.755 MB Rangées retournées : 0

SELECT product_parent_id, product_id, product_tax_id 
  FROM wm9td_hikashop_product 
  WHERE product_parent_id IN ('100') 
  AND product_published = 1 
  AND product_type = 'variant' 
  AND product_sale_start < 1675256153 
  AND (product_sale_end > 1675256153 OR product_sale_end = 0)

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wm9td_hikashop_product	NULL	ref	product_parent_id	product_parent_id	4	const	1	5.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:991
24	hikashopCurrencyClass->_loadProductVariants()	JROOT/administrator/components/com_hikashop/classes/currency.php:516
23	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:478
22	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:2453
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.05 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.769 MB Rangées retournées : 0

SELECT * 
  FROM wm9td_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND (discount_quota > discount_used_times OR discount_quota = 0) 
  AND discount_start < 1675256153 
  AND (discount_end > 1675256153 OR discount_end = 0) 
  AND ( (discount_product_id IN ('','0','100')) OR (discount_product_id LIKE '%,100,%') ) 
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wm9td_hikashop_discount	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	13	7.69	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:558
23	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:478
22	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:2453
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.04 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.781 MB Rangées retournées : 2

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

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.37 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:473
24	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:566
23	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:478
22	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:2453
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.41 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.793 MB Rangées retournées : 1

SELECT a.*, 
  CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id 
  FROM wm9td_hikashop_price AS a 
  WHERE a.price_product_id IN (100) 
  AND a.price_currency_id IN (1,2) 
  AND a.price_start_date < 1675256153 
  AND (a.price_end_date < 1 OR a.price_end_date > 1675256153) 
  AND (a.price_access = 'all' OR a.price_access LIKE '%,1,%' OR ISNULL(a.price_access)) 
  AND (a.price_users = '' OR a.price_users LIKE '%,0,%') 
  ORDER BY a.price_site_id ASC, a.price_value DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	price_product_id	price_product_id	4	const	1	5.00	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:589
23	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:478
22	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:2453
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.52 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.808 MB Rangées retournées : 1

SELECT * 
  FROM wm9td_hikashop_currency 
  WHERE currency_id IN (1)

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1918
25	hikashopCurrencyClass->getCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:2369
24	hikashopCurrencyClass->getRounding()	JROOT/administrator/components/com_hikashop/classes/currency.php:664
23	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:478
22	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:2453
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.69 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.824 MB Rangées retournées : 2

SELECT c.*, pc.*  
  FROM wm9td_hikashop_category AS c  
  LEFT JOIN wm9td_hikashop_product_category AS pc 
  ON c.category_id = pc.category_id  
  WHERE pc.product_id IN (100);

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pc	NULL	ALL	category_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	59	10.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	urchtszt001.pc.category_id	1	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:2489
21	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:873
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.65 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.839 MB Rangées retournées : 1

SELECT COUNT( DISTINCT b.product_id ) 
  FROM wm9td_hikashop_product_category AS a 
  LEFT JOIN wm9td_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE (b.product_published = 1) 
  AND (b.product_type = 'main') 
  AND (a.category_id IN (2)) 
  ORDER BY a.ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	category_id	category_id	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	4	urchtszt001.a.product_id	1	5.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/components/com_hikashop/views/product/view.html.php:901
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.96 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.027 MB mémoire avant requête : 10.849 MB Rangées retournées : 0

SELECT * 
  FROM wm9td_hikashop_characteristic 
  WHERE characteristic_values_on_listing > 0 
  ORDER BY characteristic_ordering ASC;

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1126
21	ProductViewProduct->_loadCharacteristicsValues()	JROOT/components/com_hikashop/views/product/view.html.php:924
20	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.74 ms Après la dernière requête : 57.57 ms Mémoire de requête : 0.032 MB mémoire avant requête : 11.860 MB Rangées retournées : 1

SELECT a.id, a.link, a.params 
  FROM wm9td_menu AS a 
  INNER JOIN `wm9td_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) 
  AND a.client_id=0 
  AND (a.link='index.php?option=com_hikashop&view=category&layout=listing' OR a.link='index.php?option=com_hikashop&view=product&layout=listing') 
  AND a.language IN ('*', '', 'fr-FR')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_client_id_parent_id_alias_language	1	const	170	0.42	Using index condition; Using where
1	SIMPLE	b	NULL	eq_ref	idx_menutype	idx_menutype	98	urchtszt001.a.menutype	1	75.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1075
31	hikashop_contentLink()	JROOT/components/com_hikashop/views/product/tmpl/listing_img_description.php:15
30	include JROOT/components/com_hikashop/views/product/tmpl/listing_img_description.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
29	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
28	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing_div.php:204
27	include JROOT/components/com_hikashop/views/product/tmpl/listing_div.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
26	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
25	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing.php:270
24	include JROOT/components/com_hikashop/views/product/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
23	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
22	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
21	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2587
20	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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 : 0.07 ms Mémoire de requête : 0.032 MB mémoire avant requête : 11.880 MB Rangées retournées : 2

Requêtes dupliquées: #49 #50

SELECT c.category_id 
  FROM wm9td_hikashop_product_category AS pc 
  INNER JOIN wm9td_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1 
  WHERE pc.product_id = 100 
  ORDER BY pc.product_category_id ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	25	10.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	pc	NULL	eq_ref	category_id	category_id	8	urchtszt001.c.category_id,const	1	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
32	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1086
31	hikashop_contentLink()	JROOT/components/com_hikashop/views/product/tmpl/listing_img_description.php:15
30	include JROOT/components/com_hikashop/views/product/tmpl/listing_img_description.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
29	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
28	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing_div.php:204
27	include JROOT/components/com_hikashop/views/product/tmpl/listing_div.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
26	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
25	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing.php:270
24	include JROOT/components/com_hikashop/views/product/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
23	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
22	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
21	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2587
20	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.91 ms Après la dernière requête : 10.65 ms Mémoire de requête : 0.034 MB mémoire avant requête : 11.931 MB Rangées retournées : 2

Requêtes dupliquées: #48 #50

SELECT c.category_id 
  FROM wm9td_hikashop_product_category AS pc 
  INNER JOIN wm9td_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1 
  WHERE pc.product_id = 100 
  ORDER BY pc.product_category_id ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	25	10.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	pc	NULL	eq_ref	category_id	category_id	8	urchtszt001.c.category_id,const	1	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
35	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1086
34	hikashop_contentLink()	JROOT/components/com_hikashop/views/product/tmpl/show_popup.php:29
33	include JROOT/components/com_hikashop/views/product/tmpl/show_popup.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
32	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
31	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing_img_description.php:51
30	include JROOT/components/com_hikashop/views/product/tmpl/listing_img_description.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
29	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
28	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing_div.php:204
27	include JROOT/components/com_hikashop/views/product/tmpl/listing_div.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
26	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
25	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing.php:270
24	include JROOT/components/com_hikashop/views/product/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
23	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
22	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
21	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2587
20	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.08 ms Après la dernière requête : 11.53 ms Mémoire de requête : 0.034 MB mémoire avant requête : 11.953 MB Rangées retournées : 2

Requêtes dupliquées: #48 #49

SELECT c.category_id 
  FROM wm9td_hikashop_product_category AS pc 
  INNER JOIN wm9td_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1 
  WHERE pc.product_id = 100 
  ORDER BY pc.product_category_id ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	25	10.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	pc	NULL	eq_ref	category_id	category_id	8	urchtszt001.c.category_id,const	1	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
35	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1086
34	hikashop_contentLink()	JROOT/components/com_hikashop/views/product/tmpl/show_popup.php:29
33	include JROOT/components/com_hikashop/views/product/tmpl/show_popup.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
32	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
31	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing_img_description.php:212
30	include JROOT/components/com_hikashop/views/product/tmpl/listing_img_description.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
29	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
28	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing_div.php:204
27	include JROOT/components/com_hikashop/views/product/tmpl/listing_div.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
26	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
25	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/listing.php:270
24	include JROOT/components/com_hikashop/views/product/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
23	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
22	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
21	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2587
20	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:763
18	hikashop_getLayout()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:141
17	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2632
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:2587
13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:26
12	CategoryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2310
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2054
9	hikashopController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2288
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.20 ms Après la dernière requête : 7.44 ms Mémoire de requête : 0.027 MB mémoire avant requête : 11.566 MB Rangées retournées : 31

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

  FROM wm9td_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-02-01 12:55:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-01 12:55:54') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 1615 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	41	1.60	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	urchtszt001.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	urchtszt001.m.id	2	40.00	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
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/beez3/index.php:18
7	require JROOT/templates/beez3/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 : 1.30 ms Après la dernière requête : 9.50 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.629 MB Rangées retournées : 0

SELECT *

  FROM wm9td_banners

  WHERE '2023-02-01 12:55:54' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.32 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.02 ms
executing	0.05 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	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/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.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.35 ms Après la dernière requête : 3.36 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.653 MB Rangées retournées : 0

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM wm9td_banners as a

  LEFT JOIN wm9td_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-01 12:55:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-01 12:55:54') 
  AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
  AND a.cid = 1 
  AND cl.state = 1 
  AND a.catid IN (15)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.07 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.03 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.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]

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

Tables sélectionnées :

3 × SELECT a.id as itemid 
  FROM `wm9td_menu` as a

3 × SELECT a.id 
  FROM wm9td_menu AS a 
  INNER JOIN `wm9td_menu_types` as b 
  on a.menutype = b.menutype

3 × SELECT c.category_id 
  FROM wm9td_hikashop_product_category AS pc 
  INNER JOIN wm9td_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1

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

2 × SELECT * 
  FROM wm9td_hikashop_category

2 × SELECT a.* 
  FROM wm9td_hikashop_category AS a

2 × SELECT * 
  FROM wm9td_hikashop_file

2 × SELECT a.*,b.* 
  FROM wm9td_hikashop_category AS a 
  LEFT JOIN wm9td_hikashop_file AS b 
  ON a.category_id = b.file_ref_id 
  AND b.file_type = 'category'

2 × SELECT cart.cart_id 
  FROM wm9td_hikashop_cart AS cart

1 × SELECT `data` 
  FROM `wm9td_session`

1 × SELECT `session_id` 
  FROM `wm9td_session`

1 × SELECT id, rules 
  FROM `wm9td_viewlevels

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

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

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM wm9td_menu AS m 
  LEFT JOIN wm9td_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM wm9td_languages
```

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

1 × SELECT * 
  FROM wm9td_hikashop_confi

```
1 × SELECT * 
  FROM wm9td_menu
```

1 × SELECT COUNT(*)  
  FROM wm9td_hikashop_category AS a

1 × SELECT category_left,category_right 
  FROM wm9td_hikashop_category

1 × SELECT count(pc.product_id) AS number_of_products, pc.category_id  
  FROM wm9td_hikashop_product_category AS pc  
  INNER JOIN wm9td_hikashop_product AS p 
  ON pc.product_id = p.product_id 
  AND p.product_published > 0 
  AND p.product_parent_id = 0

1 × SELECT hk_parent.* 
  FROM wm9td_hikashop_category AS hk_cat  
  LEFT JOIN wm9td_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)

1 × SELECT * 
  FROM wm9td_hikashop_field as a

1 × SELECT DISTINCT b.* 
  FROM wm9td_hikashop_product_category AS a 
  LEFT JOIN wm9td_hikashop_product AS b 
  ON a.product_id=b.product_id

1 × SELECT variant_product_id 
  FROM wm9td_hikashop_variant

1 × SELECT product_id 
  FROM wm9td_hikashop_product_related

1 × SELECT product_parent_id, product_id, product_tax_id 
  FROM wm9td_hikashop_product

1 × SELECT * 
  FROM wm9td_hikashop_discount

1 × SELECT currency_id 
  FROM wm9td_hikashop_currency

1 × SELECT a.*, 
  CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id 
  FROM wm9td_hikashop_price AS a

1 × SELECT * 
  FROM wm9td_hikashop_currency

1 × SELECT c.*, pc.*  
  FROM wm9td_hikashop_category AS c  
  LEFT JOIN wm9td_hikashop_product_category AS pc 
  ON c.category_id = pc.category_id

1 × SELECT COUNT( DISTINCT b.product_id ) 
  FROM wm9td_hikashop_product_category AS a 
  LEFT JOIN wm9td_hikashop_product AS b 
  ON a.product_id=b.product_id

1 × SELECT * 
  FROM wm9td_hikashop_characteristic

1 × SELECT a.id, a.link, a.params 
  FROM wm9td_menu AS a 
  INNER JOIN `wm9td_menu_types` AS b 
  ON a.menutype = b.menutype

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

```
1 × SELECT * 
  FROM wm9td_banners
```

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM wm9td_banners as a 
  LEFT JOIN wm9td_banner_clients AS cl 
  ON cl.id = a.cid

Autres tables :

1 × INSERT INTO `wm9td_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  (X'6539656239636632343361663731336332613065633936343766353133353265', 1, 1675256153, 0, ''

1 × UPDATE `wm9td_extensions` 
  SET `params` = '{\"mediaversion\":\"7af1551c25bc3f74a6c7d3ccb90aaa03\"}'

Union des RadioClubs

Navigation de recherche

Navigation

Recherche

Assemblée générale (0)

Assemblée Générale 2015

Lillers

14 novembre 2014

Boutique (43)

Bienvenue à la boutique de l'URC

Téléchargements (0)

Décodeur CW Arduino

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

53 requêtes exécutées 69.97 ms

12 doubles découverts!

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

Tables sélectionnées :

Autres tables :