{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1664828197,
                "last": 1664828197,
                "now": 1664828197
            },
            "token": "Cxjy18gEadQxS8zgqElJ503PEFOee5pn"
        },
        "registry": {
            "com_hikashop": {
                "user_id": 0,
                "zone_id": "73"
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "fabrik": {
            "js": {
                "scripts": null,
                "cacheids": null,
                "head": {
                    "scripts": null,
                    "cache": {
                        "e251273eb74a8ee3f661a7af00915af1": "{\"\\\/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}},\"\\\/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\\\/com_hikashop\\\/js\\\/notify.min.js?v=403\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"https:\\\/\\\/la-cave-de-morgon.fr\\\/media\\\/com_acym\\\/js\\\/module.min.js?v=6192\":{\"mime\":\"text\\\/javascript\",\"defer\":true,\"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\\\/core-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":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\\\/system\\\/js\\\/caption-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}},\"\\\/media\\\/com_slideshowck\\\/assets\\\/jquery.easing.1.3.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/com_slideshowck\\\/assets\\\/camera.min.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/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
            }
        }
    }
}

Temps

Mémoire

131 requêtes exécutées 124.86 ms

1. Temps de requête : 0.89 ms Mémoire de requête : 0.027 MB mémoire avant requête : 1.184 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `tcp_session`
   
     WHERE `session_id` = 'n99efu81443mea3u075uag8ms0'

   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

   No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

   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]

   ---

2. Temps de requête : 0.81 ms Après la dernière requête : 0.80 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.264 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `tcp_session`
   
     WHERE `session_id` = 'n99efu81443mea3u075uag8ms0' 
     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

   No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

   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]

   ---

3. Temps de requête : 3.28 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.271 MB

   INSERT INTO `tcp_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('n99efu81443mea3u075uag8ms0', 1, 1664828197, 0, '', 0)

   Explication

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

   Profil

   No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

   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]

   ---

4. Temps de requête : 0.94 ms Après la dernière requête : 2.39 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.370 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

   No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

   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]

   ---

5. Temps de requête : 1.04 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.386 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

   No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

   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]

   ---

6. Temps de requête : 2.45 ms Après la dernière requête : 19.47 ms Mémoire de requête : 0.010 MB mémoire avant requête : 2.884 MB

   UPDATE `tcp_extensions`
   
     SET `params` = '{\"mediaversion\":\"66188b7eff0eb8eec68d6ede5c8dcc0c\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explication

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

   Profil

   No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

   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]

   ---

7. Temps de requête : 1.01 ms Après la dernière requête : 4.93 ms Mémoire de requête : 0.100 MB mémoire avant requête : 3.538 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

   No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

   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]

   ---

8. Temps de requête : 1.04 ms Après la dernière requête : 13.24 ms Mémoire de requête : 0.037 MB mémoire avant requête : 4.606 MB Rangées retournées : 49

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `tcp_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cookiesck','com_cpanel','com_fabrik','com_ffexplorer','com_fields','com_finder','com_hikashop','com_imageeffectck','com_installer','com_jce','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_pagebuilderck','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_systempay','com_tags','com_templateck','com_templates','com_users','com_wrapper')

   Explication

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

   Profil

   No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
   11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
   10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
   9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.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]

   ---

9. Temps de requête : 0.68 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.034 MB mémoire avant requête : 4.683 MB Rangées retournées : 32

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `tcp_assets`
   
     WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

   Explication

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

   Profil

   No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
   16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
   15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
   14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
   11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
   10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
   9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.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]

   ---

10. Temps de requête : 1.66 ms Après la dernière requête : 0.68 ms Mémoire de requête : 0.039 MB mémoire avant requête : 4.793 MB Rangées retournées : 31

    SHOW FULL COLUMNS 
      FROM `tcp_content`

    Explication

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

    Profil

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

11. Temps de requête : 0.98 ms Après la dernière requête : 1.10 ms Mémoire de requête : 0.185 MB mémoire avant requête : 4.879 MB Rangées retournées : 1

    SELECT *
    
      FROM tcp_content
    
      WHERE `id` = '2'

    Explication

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

    Profil

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

12. Temps de requête : 2.87 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.007 MB mémoire avant requête : 5.036 MB

    UPDATE tcp_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '2'

    Explication

    EXPLAIN impossible sur la requête : UPDATE tcp_content SET `hits` = (`hits` + 1) WHERE `id` = '2'

    Profil

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

13. Temps de requête : 1.45 ms Après la dernière requête : 0.88 ms Mémoire de requête : 0.156 MB mémoire avant requête : 5.083 MB Rangées retournées : 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM tcp_content AS a
    
      INNER JOIN tcp_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN tcp_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN tcp_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN tcp_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 2 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-10-03 20:16:37') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-10-03 20:16:37') 
      AND (a.state = 1 OR a.state =2)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

    Profil

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

14. Temps de requête : 1.44 ms Après la dernière requête : 1.91 ms Mémoire de requête : 0.037 MB mémoire avant requête : 5.257 MB Rangées retournées : 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `tcp_contentitem_tag_map` AS m 
    
      INNER JOIN `tcp_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

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

    Profil

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

15. Temps de requête : 0.89 ms Après la dernière requête : 34.04 ms Mémoire de requête : 0.033 MB mémoire avant requête : 5.758 MB Rangées retournées : 1
    Requêtes dupliquées: #46

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM tcp_modules AS m
    
      LEFT JOIN tcp_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN tcp_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-10-03 20:16:37') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-10-03 20:16:37') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND m.id = 171

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	const,const	1	Using index condition; Using where

    Profil

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    20	JDatabaseDriver->loadObject()	JROOT/components/com_pagebuilderck/models/page.php:501
    19	PagebuilderckModelPage->getModule()	JROOT/components/com_pagebuilderck/models/page.php:440
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

16. Temps de requête : 0.58 ms Après la dernière requête : 2.81 ms Mémoire de requête : 0.035 MB mémoire avant requête : 6.095 MB Rangées retournées : 0
    Requêtes dupliquées: #47  #65  #88  #128

    SELECT cart.cart_id 
      FROM tcp_hikashop_cart AS cart  
      WHERE (cart.cart_type = 'cart') 
      AND (cart.session_id = 'n99efu81443mea3u075uag8ms0')  
      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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    28	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
    27	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:91
    26	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:447
    25	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:509
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

17. Temps de requête : 0.50 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.115 MB Rangées retournées : 1
    Requêtes dupliquées: #48

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

    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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    25	JDatabaseDriver->loadColumn()	JROOT/components/com_hikashop/views/product/view.html.php:533
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

18. Temps de requête : 0.44 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.039 MB mémoire avant requête : 6.153 MB Rangées retournées : 0
    Requêtes dupliquées: #49  #67  #90

    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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    27	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/filter.php:293
    26	hikashopFilterClass->getFilters()	JROOT/components/com_hikashop/views/product/view.html.php:139
    25	ProductViewProduct->filter()	JROOT/components/com_hikashop/views/product/view.html.php:559
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

19. Temps de requête : 1.38 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.044 MB mémoire avant requête : 6.176 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 = 18 
      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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:725
    27	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/filter.php:313
    26	hikashopFilterClass->getFilters()	JROOT/components/com_hikashop/views/product/view.html.php:139
    25	ProductViewProduct->filter()	JROOT/components/com_hikashop/views/product/view.html.php:559
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

20. Temps de requête : 0.74 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.047 MB mémoire avant requête : 6.206 MB Rangées retournées : 1
    Requêtes dupliquées: #50

    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 = 18 
      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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/category.php:35
    25	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:562
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

21. Temps de requête : 0.77 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.035 MB mémoire avant requête : 6.233 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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    28	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
    27	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:206
    26	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
    25	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:735
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

22. Temps de requête : 0.70 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.036 MB mémoire avant requête : 6.252 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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    28	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
    27	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:211
    26	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
    25	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:735
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

23. Temps de requête : 2.10 ms Après la dernière requête : 1.73 ms Mémoire de requête : 0.053 MB mémoire avant requête : 6.560 MB Rangées retournées : 4
    Requêtes dupliquées: #51

    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 (18)) 
      AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) 
      ORDER BY a.ordering ASC 
      LIMIT 0, 4

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	category_id,product_id	category_id	4	const	4	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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:816
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

24. Temps de requête : 0.58 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.037 MB mémoire avant requête : 6.621 MB Rangées retournées : 4
    Requêtes dupliquées: #52

    SELECT * 
      FROM tcp_hikashop_file 
      WHERE file_ref_id IN (3,4,2,1) 
      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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1721
    25	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

25. Temps de requête : 0.41 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.647 MB Rangées retournées : 0
    Requêtes dupliquées: #53

    SELECT variant_product_id 
      FROM tcp_hikashop_variant 
      WHERE variant_product_id IN (3,4,2,1)

    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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1742
    25	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

26. Temps de requête : 0.41 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.664 MB Rangées retournées : 0
    Requêtes dupliquées: #54

    SELECT product_id 
      FROM tcp_hikashop_product_related 
      WHERE product_related_type = 'options' 
      AND product_id IN (3,4,2,1)

    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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1758
    25	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

27. Temps de requête : 0.53 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.036 MB mémoire avant requête : 6.683 MB Rangées retournées : 0

    SELECT product_parent_id, product_id 
      FROM tcp_hikashop_product 
      WHERE product_parent_id IN ('3','4','2','1') 
      AND product_published = 1 
      AND product_type = 'variant' 
      AND product_sale_start < 1664828197 
      AND (product_sale_end > 1664828197 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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    29	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:951
    28	hikashopCurrencyClass->_loadProductVariants()	JROOT/administrator/components/com_hikashop/classes/currency.php:512
    27	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
    26	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
    25	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

28. Temps de requête : 0.56 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.047 MB mémoire avant requête : 6.705 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 < 1664828197 
      AND (discount_end > 1664828197 OR discount_end = 0) 
      AND ( (discount_product_id IN ('','0','3','4','2','1')) OR (discount_product_id LIKE '%,3,%') OR (discount_product_id LIKE '%,4,%') OR (discount_product_id LIKE '%,2,%') OR (discount_product_id LIKE '%,1,%') ) 
      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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:554
    27	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
    26	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
    25	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

29. Temps de requête : 0.50 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.036 MB mémoire avant requête : 6.724 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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:469
    28	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:562
    27	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
    26	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
    25	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

30. Temps de requête : 0.71 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.039 MB mémoire avant requête : 6.743 MB Rangées retournées : 4

    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 (3,4,2,1) 
      AND a.price_currency_id IN (1,2) 
      AND a.price_start_date < 1664828197 
      AND (a.price_end_date < 1 OR a.price_end_date > 1664828197) 
      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	range	price_product_id	price_product_id	4	NULL	4	Using index condition; Using where; Utilisation du tri complet de type filesort

    Profil

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:580
    27	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
    26	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
    25	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

31. Temps de requête : 0.46 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.040 MB mémoire avant requête : 6.770 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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    30	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1787
    29	hikashopCurrencyClass->getCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:2184
    28	hikashopCurrencyClass->getRounding()	JROOT/administrator/components/com_hikashop/classes/currency.php:652
    27	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
    26	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
    25	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:833
    24	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
    23	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    22	hikashop_getLayout()	JROOT/modules/mod_hikashop/mod_hikashop.php:73
    21	include JROOT/modules/mod_hikashop/mod_hikashop.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
    18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
    17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
    16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
    15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
    14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

32. Temps de requête : 0.66 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.042 MB mémoire avant requête : 6.798 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 <= 1664828197 
      AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1664828197) 
      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	Extra
    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

    No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    30	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:195
    29	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    28	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:653
    27	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
    26	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1773
    25	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/prod