product category

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701374609,
                "last": 1701374609,
                "now": 1701374609
            },
            "token": "pXYYwwE4OT1NpsE2znqLKEAI6RUOotKH"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": "73",
                "product_hikashop_category_information_menu_135_2": {
                    "limitstart": 21
                }
            },
            "com_installer": {
                "message": "",
                "extension_message": "",
                "update": {
                    "limitstart": 21
                }
            }
        },
        "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
        },
        "fabrik": {
            "js": {
                "scripts": null,
                "cacheids": null,
                "head": {
                    "scripts": null,
                    "cache": {
                        "0eb1115e926f2d70f153450c7a62cd2e": "{\"\\\/media\\\/jui\\\/js\\\/jquery.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/jui\\\/js\\\/jquery-noconflict.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/com_hikashop\\\/js\\\/hikashop.js?v=403\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/jui\\\/js\\\/jquery-migrate.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/com_hikashop\\\/js\\\/notify.min.js?v=403\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/system\\\/js\\\/core-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/modals\\\/js\\\/jquery.touchSwipe.min.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"framework\":false,\"relative\":true,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/modals\\\/js\\\/jquery.modals.js?v=11.5.5\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/modals\\\/js\\\/script.js?v=11.5.5\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/jui\\\/js\\\/bootstrap.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/components\\\/com_pagebuilderck\\\/assets\\\/jquery-uick.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_pagebuilderck\\\/assets\\\/pagebuilderck.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_pagebuilderck\\\/assets\\\/parallaxbackground.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/system\\\/js\\\/mootools-core-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/system\\\/js\\\/punycode-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/validate-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/html5fallback-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"conditional\":\"lt IE 9\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/com_hikashop\\\/js\\\/vex.min.js?v=403\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/plugins\\\/hikashop\\\/cartnotify\\\/media\\\/notify-vex.js\":{\"type\":\"text\\\/javascript\",\"options\":[]}}"
                    }
                },
                "config": null,
                "shim": null,
                "jlayouts": null
            }
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 5.80 ms / 5.80 ms Mémoire: 0.583 MB / 0.92 MB Application: afterLoad

Temps: 69.79 ms / 75.59 ms Mémoire: 2.880 MB / 3.80 MB Application: afterInitialise

Temps: 9.65 ms / 85.24 ms Mémoire: 0.726 MB / 4.52 MB Application: afterRoute

Temps: 1.32 ms / 86.56 ms Mémoire: 0.027 MB / 4.55 MB Application: beforeRenderComponent com_hikashop

Temps: 66.92 ms / 153.47 ms Mémoire: 2.020 MB / 6.57 MB Application: afterRenderComponent com_hikashop

Temps: 16.12 ms / 169.60 ms Mémoire: 0.176 MB / 6.74 MB Application: afterDispatch

Temps: 3.86 ms / 173.46 ms Mémoire: 0.279 MB / 7.02 MB Application: beforeRenderModule mod_menu (Menu Footer)

Temps: 2.02 ms / 175.48 ms Mémoire: 0.038 MB / 7.06 MB Application: afterRenderModule mod_menu (Menu Footer)

Temps: 0.21 ms / 175.69 ms Mémoire: 0.000 MB / 7.04 MB Application: beforeRenderModule mod_pagebuilderck (Bannière Alcool)

Temps: 6.41 ms / 182.11 ms Mémoire: 0.298 MB / 7.34 MB Application: afterRenderModule mod_pagebuilderck (Bannière Alcool)

Temps: 0.35 ms / 182.45 ms Mémoire: 0.038 MB / 7.38 MB Application: beforeRenderModule mod_pagebuilderck (Footer - Infos new)

Temps: 13.80 ms / 196.25 ms Mémoire: 0.113 MB / 7.49 MB Application: afterRenderModule mod_pagebuilderck (Footer - Infos new)

Temps: 0.21 ms / 196.46 ms Mémoire: 0.000 MB / 7.39 MB Application: beforeRenderModule mod_pagebuilderck (Zone de rassurance)

Temps: 5.42 ms / 201.88 ms Mémoire: 0.059 MB / 7.45 MB Application: afterRenderModule mod_pagebuilderck (Zone de rassurance)

Temps: 0.06 ms / 201.94 ms Mémoire: 0.000 MB / 7.39 MB Application: beforeRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 2.65 ms / 204.59 ms Mémoire: 0.014 MB / 7.40 MB Application: afterRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 0.31 ms / 204.91 ms Mémoire: 0.018 MB / 7.42 MB Application: beforeRenderModule mod_menu (Menu principal)

Temps: 1.17 ms / 206.07 ms Mémoire: 0.040 MB / 7.46 MB Application: afterRenderModule mod_menu (Menu principal)

Temps: 0.40 ms / 206.47 ms Mémoire: 0.000 MB / 7.45 MB Application: beforeRenderModule mod_menu (Menu user)

Temps: 0.68 ms / 207.15 ms Mémoire: 0.012 MB / 7.47 MB Application: afterRenderModule mod_menu (Menu user)

Temps: 0.20 ms / 207.36 ms Mémoire: 0.000 MB / 7.45 MB Application: beforeRenderModule mod_hikashop_cart (Hikashop_cart - Panier)

Temps: 2.56 ms / 209.92 ms Mémoire: 0.032 MB / 7.48 MB Application: afterRenderModule mod_hikashop_cart (Hikashop_cart - Panier)

Temps: 0.31 ms / 210.23 ms Mémoire: 0.005 MB / 7.48 MB Application: beforeRenderModule mod_search (Recherche)

Temps: 1.30 ms / 211.53 ms Mémoire: 0.018 MB / 7.50 MB Application: afterRenderModule mod_search (Recherche)

Temps: 0.22 ms / 211.75 ms Mémoire: 0.000 MB / 7.47 MB Application: beforeRenderModule mod_pagebuilderck (Menu Haut de Page)

Temps: 0.20 ms / 211.95 ms Mémoire: 0.004 MB / 7.48 MB Application: afterRenderModule mod_pagebuilderck (Menu Haut de Page)

Temps: 286.42 ms / 498.38 ms Mémoire: 1.282 MB / 8.76 MB Application: Before Access::preloadComponents (all components)

Temps: 1.21 ms / 499.58 ms Mémoire: 0.071 MB / 8.83 MB Application: After Access::preloadComponents (all components)

Temps: 0.04 ms / 499.62 ms Mémoire: 0.000 MB / 8.83 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Temps: 0.25 ms / 499.87 ms Mémoire: 0.008 MB / 8.84 MB Application: After Access::getAssetRules (id:1 name:root.1)

Temps: 4691.13 ms / 5191.00 ms Mémoire: 0.433 MB / 9.27 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

89 requêtes exécutées 275.82 ms

4 doubles découverts!

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

2 requêtes dupliquées: #10 #57

Temps de requête : 0.88 ms Mémoire de requête : 0.027 MB mémoire avant requête : 1.186 MB Rangées retournées : 0

SELECT `data`

  FROM `tcp_session`

  WHERE `session_id` = '76ttvo56b7kmm5buegmbvbcnd6'

Explication

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.03 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.05 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.81 ms Après la dernière requête : 0.72 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.266 MB Rangées retournées : 0

SELECT `session_id`

  FROM `tcp_session`

  WHERE `session_id` = '76ttvo56b7kmm5buegmbvbcnd6' 
  LIMIT 1

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.03 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 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:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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 : 19.75 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.274 MB

INSERT INTO `tcp_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('76ttvo56b7kmm5buegmbvbcnd6', 1, 1701374609, 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `tcp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('76ttvo56b7kmm5buegmbvbcnd6', 1, 1701374609, 0, '', 0)

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.07 ms
init	0.04 ms
update	0.11 ms
Waiting for query cache lock	0.03 ms
update	0.03 ms
end	0.02 ms
query end	19.08 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.47 ms Après la dernière requête : 1.29 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.373 MB Rangées retournées : 7

SELECT id, rules

  FROM `tcp_viewlevels`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
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:321
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:196
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.025 MB mémoire avant requête : 1.388 MB Rangées retournées : 2

SELECT b.id

  FROM tcp_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:321
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:196
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.38 ms Après la dernière requête : 28.73 ms Mémoire de requête : 0.010 MB mémoire avant requête : 2.887 MB

UPDATE `tcp_extensions`

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

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

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.10 ms
updating	0.07 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	1.85 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2755
10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57
8	plgSystemHikashopgeolocation->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
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.98 ms Après la dernière requête : 4.85 ms Mémoire de requête : 0.100 MB mémoire avant requête : 3.540 MB Rangées retournées : 333

SELECT * 
  FROM tcp_hikashop_config

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
12	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1071
11	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2774
10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57
8	plgSystemHikashopgeolocation->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
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 : 12.64 ms Mémoire de requête : 0.036 MB mémoire avant requête : 4.675 MB Rangées retournées : 1

SELECT * 
  FROM tcp_menu 
  WHERE id = '135' 
  LIMIT 0, 1

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	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
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2069
17	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/menus.php:20
16	hikashopMenusClass->get()	JROOT/administrator/components/com_hikashop/helpers/module.php:229
15	hikashopModuleHelper->_getParams()	JROOT/administrator/components/com_hikashop/helpers/module.php:14
14	hikashopModuleHelper->initialize()	JROOT/components/com_hikashop/views/product/view.html.php:176
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.49 ms Après la dernière requête : 1.08 ms Mémoire de requête : 0.037 MB mémoire avant requête : 4.812 MB Rangées retournées : 1

Requêtes dupliquées: #15

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2069
15	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/category.php:38
14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:458
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.55 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.029 MB mémoire avant requête : 4.854 MB Rangées retournées : 0

Requêtes dupliquées: #57

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
16	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:91
15	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:447
14	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:509
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.46 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.866 MB Rangées retournées : 1

SELECT category_id 
  FROM tcp_hikashop_category 
  WHERE (category_access = 'all' OR category_access LIKE '%,9,%') 
  AND category_id IN ('2')

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
14	JDatabaseDriver->loadColumn()	JROOT/components/com_hikashop/views/product/view.html.php:533
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.50 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.033 MB mémoire avant requête : 4.961 MB Rangées retournées : 0

SELECT * 
  FROM tcp_hikashop_filter 
  WHERE filter_published = 1 
  AND (filter_access = 'all' OR filter_access LIKE '%,9,%') 
  ORDER BY filter_ordering

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/filter.php:293
15	hikashopFilterClass->getFilters()	JROOT/components/com_hikashop/views/product/view.html.php:139
14	ProductViewProduct->filter()	JROOT/components/com_hikashop/views/product/view.html.php:559
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.38 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.037 MB mémoire avant requête : 4.974 MB Rangées retournées : 2

SELECT hk_parent.* 
  FROM tcp_hikashop_category AS hk_cat  
  LEFT JOIN tcp_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hk_cat	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	hk_parent	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	27	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Creating tmp table	0.47 ms
Copying to tmp table	0.11 ms
Sorting result	0.05 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.13 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:725
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/filter.php:313
15	hikashopFilterClass->getFilters()	JROOT/components/com_hikashop/views/product/view.html.php:139
14	ProductViewProduct->filter()	JROOT/components/com_hikashop/views/product/view.html.php:559
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.70 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.040 MB mémoire avant requête : 4.992 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/category.php:35
14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:562
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.47 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.037 MB mémoire avant requête : 5.008 MB Rangées retournées : 1

Requêtes dupliquées: #9

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

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	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
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2069
16	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/category.php:38
15	hikashopCategoryClass->get()	JROOT/administrator/components/com_hikashop/classes/category.php:492
14	hikashopCategoryClass->getChildren()	JROOT/components/com_hikashop/views/product/view.html.php:601
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.56 ms Après la dernière requête : 1.46 ms Mémoire de requête : 0.043 MB mémoire avant requête : 5.240 MB Rangées retournées : 14

SELECT a.* 
  FROM tcp_hikashop_category AS a 
  WHERE a.category_left > 2 
  AND a.category_right < 31 
  AND (a.category_type = 'product' OR a.category_type = 'vendor') 
  AND a.category_published=1 
  AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:569
14	hikashopCategoryClass->getChildren()	JROOT/components/com_hikashop/views/product/view.html.php:601
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.75 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.030 MB mémoire avant requête : 5.299 MB Rangées retournées : 0

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

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:206
15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:735
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.10 ms Mémoire de requête : 0.030 MB mémoire avant requête : 5.312 MB Rangées retournées : 13

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

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:211
15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:735
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.73 ms Après la dernière requête : 0.42 ms Mémoire de requête : 0.058 MB mémoire avant requête : 5.327 MB Rangées retournées : 17

SELECT DISTINCT b.* 
  FROM tcp_hikashop_product_category AS a 
  LEFT JOIN tcp_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 (12,13,14,15,16,17,18,19,22,24,25,26,27,28,2)) 
  AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) 
  ORDER BY a.ordering ASC 
  LIMIT 21, 21

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	category_id,product_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	66	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	b	eq_ref	PRIMARY,product_main_index	PRIMARY	4	cmp0912db.a.product_id	1	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.01 ms
Creating tmp table	0.94 ms
Copying to tmp table	2.30 ms
Sorting result	0.08 ms
Sending data	0.55 ms
end	0.02 ms
removing tmp table	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.05 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:816
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.89 ms Mémoire de requête : 0.033 MB mémoire avant requête : 5.510 MB Rangées retournées : 17

SELECT * 
  FROM tcp_hikashop_file 
  WHERE file_ref_id IN (19,24,29,38,10,23,30,39,11,21,31,42,32,33,34,22,44) 
  AND file_type IN ('product','file') 
  ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
Sorting result	0.06 ms
Sending data	0.29 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1721
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.39 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.028 MB mémoire avant requête : 5.556 MB Rangées retournées : 0

SELECT variant_product_id 
  FROM tcp_hikashop_variant 
  WHERE variant_product_id IN (19,24,29,38,10,23,30,39,11,21,31,42,32,33,34,22,44)

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1742
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.40 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.028 MB mémoire avant requête : 5.567 MB Rangées retournées : 0

SELECT product_id 
  FROM tcp_hikashop_product_related 
  WHERE product_related_type = 'options' 
  AND product_id IN (19,24,29,38,10,23,30,39,11,21,31,42,32,33,34,22,44)

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1758
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.55 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.030 MB mémoire avant requête : 5.581 MB Rangées retournées : 0

SELECT product_parent_id, product_id 
  FROM tcp_hikashop_product 
  WHERE product_parent_id IN ('19','24','29','38','10','23','30','39','11','21','31','42','32','33','34','22','44') 
  AND product_published = 1 
  AND product_type = 'variant' 
  AND product_sale_start < 1701374609 
  AND (product_sale_end > 1701374609 OR product_sale_end = 0)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tcp_hikashop_product	ref	product_parent_id,product_main_index	product_main_index	767	const	1	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:951
17	hikashopCurrencyClass->_loadProductVariants()	JROOT/administrator/components/com_hikashop/classes/currency.php:512
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.60 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.041 MB mémoire avant requête : 5.601 MB Rangées retournées : 0

SELECT * 
  FROM tcp_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND (discount_quota > discount_used_times OR discount_quota = 0) 
  AND discount_start < 1701374609 
  AND (discount_end > 1701374609 OR discount_end = 0) 
  AND ( (discount_product_id IN ('','0','19','24','29','38','10','23','30','39','11','21','31','42','32','33','34','22','44')) OR (discount_product_id LIKE '%,19,%') OR (discount_product_id LIKE '%,24,%') OR (discount_product_id LIKE '%,29,%') OR (discount_product_id LIKE '%,38,%') OR (discount_product_id LIKE '%,10,%') OR (discount_product_id LIKE '%,23,%') OR (discount_product_id LIKE '%,30,%') OR (discount_product_id LIKE '%,39,%') OR (discount_product_id LIKE '%,11,%') OR (discount_product_id LIKE '%,21,%') OR (discount_product_id LIKE '%,31,%') OR (discount_product_id LIKE '%,42,%') OR (discount_product_id LIKE '%,32,%') OR (discount_product_id LIKE '%,33,%') OR (discount_product_id LIKE '%,34,%') OR (discount_product_id LIKE '%,22,%') OR (discount_product_id LIKE '%,44,%') ) 
  AND (discount_flat_amount != 0 OR discount_percent_amount != 0) 
  AND (discount_flat_amount = 0 OR discount_currency_id =1) 
  AND (discount_access = 'all' OR discount_access LIKE '%,9,%') 
  AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.10 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:554
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.48 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.030 MB mémoire avant requête : 5.614 MB Rangées retournées : 2

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:469
17	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:562
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.14 ms Mémoire de requête : 0.036 MB mémoire avant requête : 5.625 MB Rangées retournées : 17

SELECT a.*, 
  CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id 
  FROM tcp_hikashop_price AS a 
  WHERE a.price_product_id IN (19,24,29,38,10,23,30,39,11,21,31,42,32,33,34,22,44) 
  AND a.price_currency_id IN (1,2) 
  AND a.price_start_date < 1701374609 
  AND (a.price_end_date < 1 OR a.price_end_date > 1701374609) 
  AND (a.price_access = 'all' OR a.price_access LIKE '%,9,%' 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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	price_product_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	43	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
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.13 ms
Sending data	0.31 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.21 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:580
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.43 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.034 MB mémoire avant requête : 5.668 MB Rangées retournées : 1

SELECT * 
  FROM tcp_hikashop_currency 
  WHERE currency_id IN (1)

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1787
18	hikashopCurrencyClass->getCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:2184
17	hikashopCurrencyClass->getRounding()	JROOT/administrator/components/com_hikashop/classes/currency.php:652
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.63 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.036 MB mémoire avant requête : 5.753 MB Rangées retournées : 1

SELECT b.*,c.* 
  FROM tcp_hikashop_category AS a 
  LEFT JOIN tcp_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN tcp_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey 
  WHERE a.category_id = 21 
  AND b.taxation_published=1 
  AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
  AND b.taxation_date_start <= 1701374609 
  AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1701374609) 
  AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') 
  ORDER BY b.taxation_id ASC

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.17 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:195
18	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
17	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:653
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.43 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.033 MB mémoire avant requête : 5.770 MB Rangées retournées : 1

SELECT * 
  FROM tcp_hikashop_zone 
  WHERE zone_id = 73

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/currency.php:216
18	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
17	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:653
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.79 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.048 MB mémoire avant requête : 5.835 MB Rangées retournées : 20

SELECT c.*, pc.*  
  FROM tcp_hikashop_category AS c  
  LEFT JOIN tcp_hikashop_product_category AS pc 
  ON c.category_id = pc.category_id  
  WHERE pc.product_id IN (19,24,29,38,10,23,30,39,11,21,31,42,32,33,34,22,44);

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	category_id,product_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	66	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	cmp0912db.pc.category_id	1

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.40 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:1695
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1808
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.26 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.038 MB mémoire avant requête : 5.928 MB Rangées retournées : 5

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.02 ms
Creating tmp table	0.38 ms
Copying to tmp table	0.10 ms
Sorting result	0.05 ms
Sending data	0.12 ms
end	0.01 ms
removing tmp table	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.22 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:725
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/badge.php:111
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.51 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.034 MB mémoire avant requête : 5.961 MB Rangées retournées : 0

SELECT a.* 
  FROM tcp_hikashop_badge AS a 
  WHERE a.badge_start <= 1701374609 
  AND (a.badge_end >= 1701374609 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '20' OR badge_category_id LIKE '%,20,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '24' OR badge_category_id LIKE '%,24,%' OR badge_category_id = '12' OR badge_category_id LIKE '%,12,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.22 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:148
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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 : 0.13 ms Mémoire de requête : 0.040 MB mémoire avant requête : 5.978 MB Rangées retournées : 6

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hk_cat	range	PRIMARY	PRIMARY	4	NULL	2	Using index condition; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	hk_parent	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	27	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.41 ms
Copying to tmp table	0.16 ms
Sorting result	0.05 ms
Sending data	0.13 ms
end	0.01 ms
removing tmp table	0.11 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.22 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:725
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/badge.php:111
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.51 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.016 MB Rangées retournées : 0

SELECT a.* 
  FROM tcp_hikashop_badge AS a 
  WHERE a.badge_start <= 1701374609 
  AND (a.badge_end >= 1701374609 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '20' OR badge_category_id LIKE '%,20,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '24' OR badge_category_id LIKE '%,24,%' OR badge_category_id = '12' OR badge_category_id LIKE '%,12,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.22 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:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:148
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.23 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.038 MB mémoire avant requête : 6.025 MB Rangées retournées : 4

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.02 ms
Creating tmp table	0.37 ms
Copying to tmp table	0.10 ms
Sorting result	0.04 ms
Sending data	0.10 ms
end	0.02 ms
removing tmp table	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.21 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:725
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/badge.php:111
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.50 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.054 MB Rangées retournées : 0

SELECT a.* 
  FROM tcp_hikashop_badge AS a 
  WHERE a.badge_start <= 1701374609 
  AND (a.badge_end >= 1701374609 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '22' OR badge_category_id LIKE '%,22,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '22' OR badge_category_id LIKE '%,22,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.22 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:148
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.13 ms Mémoire de requête : 0.038 MB mémoire avant requête : 6.064 MB Rangées retournées : 3

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.02 ms
Creating tmp table	0.41 ms
Copying to tmp table	0.10 ms
Sorting result	0.04 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.22 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:725
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/badge.php:111
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.48 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.089 MB Rangées retournées : 0

SELECT a.* 
  FROM tcp_hikashop_badge AS a 
  WHERE a.badge_start <= 1701374609 
  AND (a.badge_end >= 1701374609 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '26' OR badge_category_id LIKE '%,26,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '26' OR badge_category_id LIKE '%,26,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.22 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:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:148
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.28 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.038 MB mémoire avant requête : 6.099 MB Rangées retournées : 5

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Creating tmp table	0.38 ms
Copying to tmp table	0.12 ms
Sorting result	0.05 ms
Sending data	0.12 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.22 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:725
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/badge.php:111
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.51 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.133 MB Rangées retournées : 0

SELECT a.* 
  FROM tcp_hikashop_badge AS a 
  WHERE a.badge_start <= 1701374609 
  AND (a.badge_end >= 1701374609 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '20' OR badge_category_id LIKE '%,20,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '24' OR badge_category_id LIKE '%,24,%' OR badge_category_id = '12' OR badge_category_id LIKE '%,12,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.22 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:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:148
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.28 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.038 MB mémoire avant requête : 6.142 MB Rangées retournées : 5

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Creating tmp table	0.40 ms
Copying to tmp table	0.10 ms
Sorting result	0.05 ms
Sending data	0.12 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.22 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:725
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/badge.php:111
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.50 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.175 MB Rangées retournées : 0

SELECT a.* 
  FROM tcp_hikashop_badge AS a 
  WHERE a.badge_start <= 1701374609 
  AND (a.badge_end >= 1701374609 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '20' OR badge_category_id LIKE '%,20,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '24' OR badge_category_id LIKE '%,24,%' OR badge_category_id = '12' OR badge_category_id LIKE '%,12,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.39 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:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:148
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.24 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.038 MB mémoire avant requête : 6.184 MB Rangées retournées : 4

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Creating tmp table	0.38 ms
Copying to tmp table	0.09 ms
Sorting result	0.04 ms
Sending data	0.10 ms
end	0.01 ms
removing tmp table	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.21 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:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:725
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/badge.php:111
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
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:196
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.49 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.214 MB Rangées retournées : 0

SELECT a.* 
  FROM tcp_hikashop_badge AS a 
  WHERE a.badge_start <= 1701374609 
  AND (a.badge_end >= 1701374609 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '20' OR badge_category_id LIKE '%,20,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '24' OR badge_category_id LIKE '%,24,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.46 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:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:148
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1824
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:42
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5