Name: Pack Prestashop SANS nom de domaine
SKU: Pack_Prestashop_sans_nom_de_domaine
Price: 45 EUR
Availability: InStock

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1782307529,
                "last": 1782307529,
                "now": 1782307529
            },
            "token": "dXit98OQNGwbtGYJtssuUd6yd9ts938t"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": "73"
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Profil d'information

Temps

Mémoire

Temps: 17.47 ms / 17.47 ms Mémoire: 0.415 MB / 0.75 MB Application: afterLoad

Temps: 202.66 ms / 220.13 ms Mémoire: 1.732 MB / 2.48 MB Application: afterInitialise

Temps: 96.82 ms / 316.95 ms Mémoire: 0.441 MB / 2.92 MB Application: afterRoute

Temps: 0.82 ms / 317.77 ms Mémoire: 0.128 MB / 3.05 MB Application: beforeRenderComponent com_hikashop

Temps: 79.18 ms / 396.95 ms Mémoire: 2.192 MB / 5.24 MB Application: beforeRenderModule mod_hikashop (Related products)

Temps: 4.41 ms / 401.36 ms Mémoire: 0.154 MB / 5.39 MB Application: afterRenderModule mod_hikashop (Related products)

Temps: 0.06 ms / 401.42 ms Mémoire: -0.057 MB / 5.34 MB Application: afterRenderComponent com_hikashop

Temps: 4.33 ms / 405.75 ms Mémoire: 0.025 MB / 5.36 MB Application: afterDispatch

Temps: 25.84 ms / 431.59 ms Mémoire: 0.259 MB / 5.62 MB Application: beforeRenderModule mod_search (Search)

Temps: 2.97 ms / 434.55 ms Mémoire: 0.051 MB / 5.67 MB Application: afterRenderModule mod_search (Search)

Temps: 0.91 ms / 435.46 ms Mémoire: -0.001 MB / 5.67 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Temps: 3.43 ms / 438.89 ms Mémoire: 0.040 MB / 5.71 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Temps: 2.34 ms / 441.23 ms Mémoire: 0.051 MB / 5.76 MB Application: beforeRenderModule mod_menu (Hébergement)

Temps: 2.37 ms / 443.60 ms Mémoire: 0.034 MB / 5.80 MB Application: afterRenderModule mod_menu (Hébergement)

Temps: 1.60 ms / 445.20 ms Mémoire: 0.020 MB / 5.82 MB Application: beforeRenderModule mod_menu (Mentions Légales)

Temps: 2.00 ms / 447.21 ms Mémoire: 0.028 MB / 5.84 MB Application: afterRenderModule mod_menu (Mentions Légales)

Temps: 1.66 ms / 448.86 ms Mémoire: 0.023 MB / 5.87 MB Application: beforeRenderModule mod_articles_latest (Derniers Ajouts)

Temps: 1.51 ms / 450.37 ms Mémoire: 0.042 MB / 5.91 MB Application: Before Access::preloadComponents (all components)

Temps: 1.15 ms / 451.52 ms Mémoire: 0.064 MB / 5.97 MB Application: After Access::preloadComponents (all components)

Temps: 0.02 ms / 451.54 ms Mémoire: -0.002 MB / 5.97 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Temps: 0.37 ms / 451.92 ms Mémoire: 0.008 MB / 5.98 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 4.70 ms / 456.61 ms Mémoire: 0.107 MB / 6.09 MB Application: afterRenderModule mod_articles_latest (Derniers Ajouts)

Temps: 1.86 ms / 458.48 ms Mémoire: -0.041 MB / 6.04 MB Application: beforeRenderModule mod_custom (Nous contacter)

Temps: 0.87 ms / 459.35 ms Mémoire: 0.006 MB / 6.05 MB Application: afterRenderModule mod_custom (Nous contacter)

Temps: 39.95 ms / 499.30 ms Mémoire: 0.015 MB / 6.06 MB Application: afterRender

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

EXPLAIN impossible sur la requête : INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'31716a6e616c616637747133666233663665396e637461716d38', 1, 1782307529, 0, '', 0)

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.08 ms
Waiting for query cache lock	0.00 ms
Update	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	116.39 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

Temps de requête : 0.95 ms Après la dernière requête : 5.26 ms Mémoire de requête : 0.056 MB mémoire avant requête : 1.083 MB Rangées retournées : 43

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

  FROM `chdg4_extensions`

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

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.05 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT id, rules

  FROM `chdg4_viewlevels`

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.20 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT b.id

  FROM chdg4_usergroups AS a

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

  WHERE a.id = 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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

Temps de requête : 0.98 ms Après la dernière requête : 1.15 ms Mémoire de requête : 0.035 MB mémoire avant requête : 1.174 MB Rangées retournées : 138

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

  FROM chdg4_extensions

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

  ORDER BY ordering

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.66 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT `template`

  FROM `chdg4_template_styles`

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT *

  FROM chdg4_languages

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:219
12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:171
11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:85
10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:101
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:103
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 15.15 ms Après la dernière requête : 2.19 ms Mémoire de requête : 0.049 MB mémoire avant requête : 2.090 MB Rangées retournées : 26

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

  FROM chdg4_menu AS m

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

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

  ORDER BY m.lft

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.29 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.05 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	14.07 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.48 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
19	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
16	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
15	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
14	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
13	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
12	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
11	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:131
10	Sh404sefClassPageinfo->loadHomepages()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:103
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:103
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `params` 
  FROM chdg4_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:160
11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:671
10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:126
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `chdg4_sh404sef_aliases` 
  WHERE `state` = 1 
  and (`alias` = 'brands-listing/product/pack-prestashop-sans-nom-de-domaine.html') 
  order by `ordering` asc

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_sh404sef_aliases	ref	state,alias	alias	573	const	1	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
16	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/models/redirector.php:222
15	Sh404sefModelRedirector->findHardcodedMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:116
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:87
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:706
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:295
10	Sh404sefClassRouterInternal->preprocessParseRule()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM chdg4_sh404sef_aliases 
  WHERE state = 1 
  and (type = 1 or type = 2);

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_sh404sef_aliases	range	type,state	type	1	NULL	2	Using index condition; Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/redirector.php:287
15	Sh404sefModelRedirector->findWildcardMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:117
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:87
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:706
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:295
10	Sh404sefClassRouterInternal->preprocessParseRule()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM chdg4_sh404sef_pageids 
  WHERE `pageid`='brands-listing/product/pack-prestashop-sans-nom-de-domaine.html';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_sh404sef_pageids	ref	alias	alias	762	const	1	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.19 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:2357
11	Sh404sefClassRouterInternal->_checkShurls()	JROOT/administrator/components/com_sh404sef/classes/router.php:296
10	Sh404sefClassRouterInternal->preprocessParseRule()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.21 ms Après la dernière requête : 0.55 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.686 MB Rangées retournées : 2

SELECT *

  FROM chdg4_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
17	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_sh404sef/classes/router.php:2067
16	Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:2035
15	Sh404sefClassRouterInternal->_isSimpleEncodingSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1978
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1439
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2664
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:457
11	Sh404sefClassRouterInternal->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM chdg4_sh404sef_urls 
  WHERE `oldurl`='brands-listing/product/pack-prestashop-sans-nom-de-domaine.html' 
  ORDER BY `rank`;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_sh404sef_urls	ref	oldurl	oldurl	573	const	1	Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1992
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1439
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2664
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:457
11	Sh404sefClassRouterInternal->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 26.79 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.720 MB

UPDATE `chdg4_sh404sef_urls` 
  SET `cpt`=2152, `last_hit`='2026-06-24 13:25:29' 
  WHERE `id`='3579' 
  AND `rank`=0;

Explication

EXPLAIN impossible sur la requête : UPDATE `chdg4_sh404sef_urls` SET `cpt`=2152, `last_hit`='2026-06-24 13:25:29' WHERE `id`='3579' AND `rank`=0;

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.05 ms
Updating	0.11 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	26.50 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
17	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:478
16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:467
15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1458
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2664
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:457
11	Sh404sefClassRouterInternal->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `chdg4_extensions`

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 39.47 ms Après la dernière requête : 0.55 ms Mémoire de requête : 0.006 MB mémoire avant requête : 2.809 MB

UPDATE `chdg4_extensions`

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

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

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.05 ms
Updating	0.05 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	39.24 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.41 ms Après la dernière requête : 4.70 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.890 MB Rangées retournées : 4

SELECT id, home, template, s.params

  FROM chdg4_template_styles as s

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

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

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.69 ms Après la dernière requête : 17.02 ms Mémoire de requête : 0.045 MB mémoire avant requête : 3.837 MB Rangées retournées : 296

SELECT * 
  FROM chdg4_hikashop_config

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.18 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:17
9	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1456
8	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3950
7	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/hikashop.php:17
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering  
  FROM chdg4_hikashop_product AS product  
  LEFT JOIN chdg4_hikashop_product_category AS product_category 
  ON product.product_id = product_category.product_id  
  WHERE (product.product_id = 6) 
  LIMIT 0, 1

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.28 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.08 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:5243
16	hikashopProductClass->loadPageProductOptions()	JROOT/administrator/components/com_hikashop/classes/product.php:5184
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM chdg4_hikashop_product 
  WHERE (product_parent_id IN (6)) 
  AND (product_published = 1)

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:5292
16	hikashopProductClass->loadPageProductVariants()	JROOT/administrator/components/com_hikashop/classes/product.php:5191
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:5338
16	hikashopProductClass->loadPageProductCharacteristics()	JROOT/administrator/components/com_hikashop/classes/product.php:5192
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:5385
16	hikashopProductClass->loadPageProductFiles()	JROOT/administrator/components/com_hikashop/classes/product.php:5193
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #42 #55

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	14.14 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:70
19	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:166
18	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:513
17	hikashop_getZone()	JROOT/administrator/components/com_hikashop/classes/product.php:5396
16	hikashopProductClass->loadPageProductPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5194
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT currency_id 
  FROM chdg4_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	chdg4_hikashop_currency	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	182	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:529
19	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:1729
18	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1691
17	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5400
16	hikashopProductClass->loadPageProductPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5194
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.*, 
  CASE WHEN p.price_site_id = 0 OR p.price_site_id = '[unselected]' THEN '' ELSE p.price_site_id END AS price_site_id 
  FROM chdg4_hikashop_price as p 
  WHERE (p.price_currency_id IN (1)) 
  AND (p.price_start_date < 1782307529) 
  AND ((p.price_end_date < 1 OR p.price_end_date > 1782307529)) 
  AND (p.price_product_id IN (6)) 
  AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) 
  ORDER BY price_site_id ASC, p.price_value DESC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1773
18	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1691
17	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5400
16	hikashopProductClass->loadPageProductPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5194
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM chdg4_hikashop_currency 
  WHERE currency_id IN (1)

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:2076
22	hikashopCurrencyClass->getCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:2555
21	hikashopCurrencyClass->getRounding()	JROOT/administrator/components/com_hikashop/classes/currency.php:2945
20	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1865
19	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1783
18	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1691
17	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5400
16	hikashopProductClass->loadPageProductPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5194
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.06 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:256
22	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:106
21	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2947
20	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1865
19	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1783
18	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1691
17	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5400
16	hikashopProductClass->loadPageProductPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5194
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM chdg4_hikashop_zone 
  WHERE zone_id = 73

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/currency.php:277
22	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:106
21	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2947
20	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1865
19	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1783
18	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1691
17	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5400
16	hikashopProductClass->loadPageProductPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5194
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.04 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1833
18	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1691
17	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5400
16	hikashopProductClass->loadPageProductPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:5194
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT category_id 
  FROM chdg4_hikashop_product_category 
  WHERE product_id IN (6) 
  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/product.php:1299
19	hikashopProductClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:312
18	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:197
17	hikashopFieldClass->getFields()	JROOT/administrator/components/com_hikashop/classes/product.php:5405
16	hikashopProductClass->loadPageProductCustomFields()	JROOT/administrator/components/com_hikashop/classes/product.php:5195
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT hk_parent.category_id, hk_parent.category_parent_id 
  FROM chdg4_hikashop_category AS hk_parent 
  WHERE  hk_parent.category_id IN (2)  
  ORDER BY hk_parent.category_left

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:785
19	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:317
18	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:197
17	hikashopFieldClass->getFields()	JROOT/administrator/components/com_hikashop/classes/product.php:5405
16	hikashopProductClass->loadPageProductCustomFields()	JROOT/administrator/components/com_hikashop/classes/product.php:5195
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id 
  FROM chdg4_hikashop_category AS hk_parent 
  WHERE  hk_parent.category_id IN (1)  
  ORDER BY hk_parent.category_left

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:785
20	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/category.php:796
19	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:317
18	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:197
17	hikashopFieldClass->getFields()	JROOT/administrator/components/com_hikashop/classes/product.php:5405
16	hikashopProductClass->loadPageProductCustomFields()	JROOT/administrator/components/com_hikashop/classes/product.php:5195
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:176
18	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:198
17	hikashopFieldClass->getFields()	JROOT/administrator/components/com_hikashop/classes/product.php:5405
16	hikashopProductClass->loadPageProductCustomFields()	JROOT/administrator/components/com_hikashop/classes/product.php:5195
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.*  
  FROM chdg4_hikashop_product_category AS a  
  LEFT JOIN chdg4_hikashop_category AS b 
  ON a.category_id = b.category_id  
  WHERE a.product_id = 6 
  ORDER BY a.ordering ASC, a.product_category_id ASC

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:5461
16	hikashopProductClass->loadPageProductCategories()	JROOT/administrator/components/com_hikashop/classes/product.php:5196
15	hikashopProductClass->loadFullProductData()	JROOT/administrator/components/com_hikashop/classes/product.php:5173
14	hikashopProductClass->loadFullProduct()	JROOT/components/com_hikashop/views/product/view.html.php:1316
13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:32
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

Temps de requête : 0.22 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.007 MB mémoire avant requête : 4.739 MB

UPDATE chdg4_hikashop_product 
  SET product_hit = product_hit + 1, product_last_seen_date = 1782307529 
  WHERE product_id = 6

Explication

EXPLAIN impossible sur la requête : UPDATE chdg4_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1782307529 WHERE product_id = 6

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.03 ms
Updating	0.06 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.04 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	10.33 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #27 #55

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT a.id 
  FROM chdg4_menu AS a 
  INNER JOIN `chdg4_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.client_id=0 
  AND a.access IN (1,1) 
  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	5	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	cybergraphik.b.menutype	10	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.35 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT a.id 
  FROM chdg4_menu AS a 
  INNER JOIN `chdg4_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.client_id=0 
  AND a.access IN (1,1) 
  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	5	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	cybergraphik.b.menutype	10	Using where

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.24 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

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

  FROM `chdg4_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.50 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.07 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

Temps de requête : 0.91 ms Après la dernière requête : 3.84 ms Mémoire de requête : 0.042 MB mémoire avant requête : 5.088 MB Rangées retournées : 41

SHOW FULL COLUMNS 
  FROM `chdg4_sh404sef_metas`

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.16 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.25 ms
After opening tables	0.01 ms
checking permissions	0.15 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.06 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
36	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
35	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
34	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
33	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:138
32	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:328
31	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:37
30	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
29	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:515
28	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:347
27	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
24	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
23	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
22	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
21	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:229
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:115
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3112
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:33
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.38 ms Après la dernière requête : 0.69 ms Mémoire de requête : 0.032 MB mémoire avant requête : 5.147 MB Rangées retournées : 0

SELECT * 
  FROM chdg4_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_hikashop&Itemid=664&cid=6&ctrl=product&lang=fr&name=pack-prestashop-sans-nom-de-domaine&task=show';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_sh404sef_metas	ref	newurl	newurl	573	const	1	Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.06 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
34	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
33	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
32	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
31	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:38
30	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
29	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:515
28	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:347
27	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
24	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
23	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
22	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
21	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:229
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:115
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3112
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:33
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM chdg4_hikashop_vote 
  WHERE vote_type = 'product' 
  AND vote_published > 0 
  AND vote_ref_id = 6

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:118
23	include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:254
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:115
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3112
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:33
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.id, a.link, a.params 
  FROM chdg4_menu AS a 
  INNER JOIN `chdg4_menu_types` AS b 
  ON a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1) 
  AND a.client_id=0 
  AND (a.link='index.php?option=com_hikashop&view=category&layout=listing' OR a.link='index.php?option=com_hikashop&view=product&layout=listing') 
  AND a.language IN ('*', '', 'fr-FR')

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.30 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1265
24	hikashop_contentLink()	JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:187
23	include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:254
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:115
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3112
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:33
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #53

SELECT c.category_id 
  FROM chdg4_hikashop_product_category AS pc 
  INNER JOIN chdg4_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1 
  WHERE pc.product_id = 6 
  ORDER BY pc.product_category_id ASC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1276
24	hikashop_contentLink()	JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:187
23	include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:254
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:115
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3112
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:33
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #54

SELECT a.id 
  FROM chdg4_menu AS a 
  INNER JOIN `chdg4_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.client_id=0 
  AND a.link LIKE 'index.php?option=com_hikashop&view=category&layout=%' 
  AND a.access IN (1,1) 
  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	5	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	cybergraphik.b.menutype	10	Using where

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.24 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
26	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:367
25	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1311
24	hikashop_contentLink()	JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:187
23	include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:254
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:115
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3112
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:33
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #51

SELECT c.category_id 
  FROM chdg4_hikashop_product_category AS pc 
  INNER JOIN chdg4_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1 
  WHERE pc.product_id = 6 
  ORDER BY pc.product_category_id ASC

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1276
24	hikashop_contentLink()	JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:212
23	include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:254
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:115
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3112
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:33
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #52

SELECT a.id 
  FROM chdg4_menu AS a 
  INNER JOIN `chdg4_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.client_id=0 
  AND a.link LIKE 'index.php?option=com_hikashop&view=category&layout=%' 
  AND a.access IN (1,1) 
  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	5	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	cybergraphik.b.menutype	10	Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.25 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
26	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:367
25	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1311
24	hikashop_contentLink()	JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:212
23	include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show_default.php:254
20	include JROOT/components/com_hikashop/views/product/tmpl/show_default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:115
17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3160
15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3112
13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:33
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2818
10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2558
9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2796
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:89
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #27 #42

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT `pageid` 
  FROM chdg4_sh404sef_pageids 
  WHERE `newurl`='index.php?option=com_hikashop&Itemid=664&cid=6&ctrl=product&lang=fr&name=pack-prestashop-sans-nom-de-domaine&task=show';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_sh404sef_pageids	ref	newurl	newurl	763	const	1	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
11	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
10	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
9	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/shurl.php:57
8	Sh404sefHelperShurl::updateShurls()	JROOT/plugins/system/sh404sef/sh404sef.php:283
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.22 ms Après la dernière requête : 16.08 ms Mémoire de requête : 0.026 MB mémoire avant requête : 5.607 MB Rangées retournées : 10

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

  FROM chdg4_modules AS m

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

  LEFT JOIN chdg4_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 <= '2026-06-24 13:25:29') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-24 13:25:29') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 664 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	59	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	cybergraphik.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	cybergraphik.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.32 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:592
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:539
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:330
8	Helix3::generatelayout()	JROOT/templates/at_hosting/index.php:169
7	require JROOT/templates/at_hosting/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `oldurl`, `dateadd` 
  FROM chdg4_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_search&Itemid=664&cid=6&ctrl=product&format=opensearch&lang=fr&name=pack-prestashop-sans-nom-de-domaine&task=show';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_sh404sef_urls	ref	newurl	newurl	573	const	1	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
31	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
30	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
29	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
28	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:779
27	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:816
26	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1538
25	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1230
24	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2675
23	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1084
22	Sh404sefClassRouterInternal->buildRule()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
20	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
18	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_search/mod_search.php:27
13	include JROOT/modules/mod_search/mod_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `oldurl` 
  FROM chdg4_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_search&Itemid=664&lang=fr&task=show';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_sh404sef_urls	ref	newurl	newurl	573	const	1	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
33	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
32	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
31	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
30	ShlDbHelper::selectResult()	JROOT/components/com_sh404sef/sef_ext.php:879
29	sef_404::sefGetLocation()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:509
28	shFinalizePlugin()	JROOT/components/com_sh404sef/sef_ext/com_search.php:69
27	include JROOT/components/com_sh404sef/sef_ext/com_search.php	JROOT/components/com_sh404sef/sef_ext.php:385
26	sef_404->create()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1786
25	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1230
24	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2675
23	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1084
22	Sh404sefClassRouterInternal->buildRule()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
20	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
18	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_search/mod_search.php:27
13	include JROOT/modules/mod_search/mod_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.97 ms Après la dernière requête : 16.40 ms Mémoire de requête : 0.030 MB mémoire avant requête : 5.914 MB Rangées retournées : 43

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

  FROM `chdg4_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advportfoliopro','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_hikashop','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sh404sef','com_sppagebuilder','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

Explication

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.03 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.20 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
23	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:442
18	ContentModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
14	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
13	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.89 ms Après la dernière requête : 0.55 ms Mémoire de requête : 0.105 MB mémoire avant requête : 5.977 MB Rangées retournées : 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM chdg4_content AS a

  LEFT JOIN chdg4_categories AS c 
  ON c.id = a.catid

  LEFT JOIN chdg4_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN chdg4_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN chdg4_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN chdg4_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-24 13:25:29') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-24 13:25:29')

  ORDER BY a.created DESC 
  LIMIT 3

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	9	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	cybergraphik.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cybergraphik.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	cybergraphik.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	cybergraphik.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	cybergraphik.a.id	1	Using where

Profil

Status	Duration
Starting	0.20 ms
checking permissions	0.01 ms
Opening tables	0.92 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.13 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.09 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.19 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
14	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
13	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.52 ms Après la dernière requête : 1.08 ms Mémoire de requête : 0.034 MB mémoire avant requête : 6.076 MB Rangées retournées : 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `chdg4_categories` AS `s`

  INNER JOIN `chdg4_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 9

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	4 (18%)	Using index condition; Using where; Using rowid filter

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
14	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
13	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Tables sélectionnées :

4 × SELECT a.id 
  FROM chdg4_menu AS a 
  INNER JOIN `chdg4_menu_types` as b 
  on a.menutype = b.menutype

3 × SELECT cart.cart_id 
  FROM chdg4_hikashop_cart AS cart

2 × SELECT c.category_id 
  FROM chdg4_hikashop_product_category AS pc 
  INNER JOIN chdg4_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1

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

```
2 × SELECT * 
  FROM chdg4_languages
```

1 × SELECT * 
  FROM chdg4_hikashop_vote

1 × SELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id 
  FROM chdg4_hikashop_category AS hk_parent

1 × SELECT * 
  FROM chdg4_hikashop_field as a

1 × SELECT b.*  
  FROM chdg4_hikashop_product_category AS a  
  LEFT JOIN chdg4_hikashop_category AS b 
  ON a.category_id = b.category_id

1 × SELECT a.* 
  FROM chdg4_hikashop_badge AS a

```
1 × SELECT * 
  FROM chdg4_modules
```

1 × SELECT a.*, c.currency_symbol 
  FROM chdg4_hikashop_shipping AS a  
  INNER JOIN chdg4_hikashop_currency AS c 
  ON c.currency_id = a.shipping_currency_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `chdg4_contentitem_tag_map` AS m  
  INNER JOIN `chdg4_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT * 
  FROM chdg4_sh404sef_metas

1 × SELECT `data` 
  FROM `chdg4_session`

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

1 × SELECT category_id 
  FROM chdg4_hikashop_product_category

1 × SELECT a.*,b.* 
  FROM chdg4_hikashop_category AS a 
  LEFT JOIN chdg4_hikashop_file AS b 
  ON a.category_id = b.file_ref_id 
  AND b.file_type = 'category'

1 × SELECT DISTINCT b.* 
  FROM chdg4_hikashop_product_related AS a 
  LEFT JOIN chdg4_hikashop_product AS b 
  ON a.product_related_id=b.product_id

1 × SELECT COUNT( DISTINCT b.product_id ) 
  FROM chdg4_hikashop_product_related AS a 
  LEFT JOIN chdg4_hikashop_product AS b 
  ON a.product_related_id=b.product_id

1 × SELECT `pageid` 
  FROM chdg4_sh404sef_pageids

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

1 × SELECT `oldurl`, `dateadd` 
  FROM chdg4_sh404sef_urls

1 × SELECT `oldurl` 
  FROM chdg4_sh404sef_urls

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `chdg4_assets`

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM chdg4_content AS a 
  LEFT JOIN chdg4_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN chdg4_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN chdg4_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN chdg4_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN chdg4_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT hk_parent.category_id, hk_parent.category_parent_id 
  FROM chdg4_hikashop_category AS hk_parent

1 × SELECT * 
  FROM chdg4_hikashop_zone

1 × SELECT * 
  FROM chdg4_hikashop_discount

1 × SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM chdg4_sh404sef_urls

1 × SELECT id, rules 
  FROM `chdg4_viewlevels

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

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

1 × SELECT `template` 
  FROM `chdg4_template_styles`

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

1 × SELECT `params` 
  FROM chdg4_extensions

1 × SELECT * 
  FROM `chdg4_sh404sef_aliases`

1 × SELECT * 
  FROM chdg4_sh404sef_aliases

1 × SELECT * 
  FROM chdg4_sh404sef_pageids

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

1 × SELECT `session_id` 
  FROM `chdg4_session`

1 × SELECT * 
  FROM chdg4_hikashop_confi

1 × SELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering  
  FROM chdg4_hikashop_product AS product  
  LEFT JOIN chdg4_hikashop_product_category AS product_category 
  ON product.product_id = product_category.product_id

1 × SELECT p.*  
  FROM chdg4_hikashop_product_related AS pr  
  LEFT JOIN chdg4_hikashop_product AS p 
  ON pr.product_related_id = p.product_id

1 × SELECT * 
  FROM chdg4_hikashop_product

1 × SELECT v.*, c.*  
  FROM chdg4_hikashop_variant AS v  
  INNER JOIN chdg4_hikashop_characteristic AS c 
  ON v.variant_characteristic_id = c.characteristic_id

1 × SELECT * 
  FROM chdg4_hikashop_file

1 × SELECT currency_id 
  FROM chdg4_hikashop_currency

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

1 × SELECT * 
  FROM chdg4_hikashop_currency

1 × SELECT b.*,c.* 
  FROM chdg4_hikashop_category AS a 
  LEFT JOIN chdg4_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN chdg4_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `chdg4_categories` AS `s` 
  INNER JOIN `chdg4_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

Autres tables :

1 × INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'31716a6e616c616637747133666233663665396e637461716d38', 1, 1782307529, 0, '', 0

1 × UPDATE `chdg4_sh404sef_urls` 
  SET `cpt`=2152, `last_hit`='2026-06-24 13:25:29'

1 × UPDATE `chdg4_extensions` 
  SET `params` = '{\"mediaversion\":\"e3e070be4d18580f2c0cb41e53c1d59c\"}'

1 × UPDATE chdg4_hikashop_product 
  SET product_hit = product_hit + 1, product_last_seen_date = 1782307529

1 × SHOW FULL COLUMNS 
  FROM `chdg4_sh404sef_metas

Pack Prestashop SANS nom de domaine

Nous contacter

Derniers Ajouts

Mentions Légales

Hébergement

Search

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

65 requêtes exécutées 252.38 ms

7 doubles découverts!

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

Tables sélectionnées :

Autres tables :