bouton de passementerie

Définition : système de fermeture en deux parties, fabriquées avec du cordon: une partie comporte un n

Découvrez le nouveau livre de Petit Citron !

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1550891844,
                "last": 1550891844,
                "now": 1550891844
            },
            "client": {
                "forwarded": "137.74.122.36"
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 4.08 ms / 4.08 ms Mémoire: 0.386 MB / 0.73 MB Application: afterLoad

Temps: 182.81 ms / 186.89 ms Mémoire: 1.301 MB / 2.03 MB Application: afterInitialise

Temps: 22.28 ms / 209.17 ms Mémoire: 0.165 MB / 2.19 MB Application: Before Access::preloadComponents (all components)

Temps: 8.30 ms / 217.47 ms Mémoire: 0.045 MB / 2.24 MB Application: After Access::preloadComponents (all components)

Temps: 0.03 ms / 217.50 ms Mémoire: 0.000 MB / 2.24 MB Application: Before Access::getAssetRules (id:53111 name:com_rantispam)

Temps: 0.75 ms / 218.25 ms Mémoire: 0.007 MB / 2.24 MB Application: After Access::getAssetRules (id:53111 name:com_rantispam)

Temps: 0.04 ms / 218.29 ms Mémoire: 0.000 MB / 2.24 MB Application: afterRoute

Temps: 14.32 ms / 232.61 ms Mémoire: 0.029 MB / 2.27 MB Application: beforeRenderComponent com_content

Temps: 3.11 ms / 235.72 ms Mémoire: 0.040 MB / 2.31 MB Application: Before Access::preloadPermissions (com_content)

Temps: 201.11 ms / 436.84 ms Mémoire: 29.070 MB / 31.38 MB Application: After Access::preloadPermissions (com_content)

Temps: 6.21 ms / 443.05 ms Mémoire: 0.000 MB / 29.88 MB Application: Before Access::getAssetRules (id:3335 name:com_content.article.3186)

Temps: 0.08 ms / 443.13 ms Mémoire: 0.005 MB / 29.88 MB Application: After Access::getAssetRules (id:3335 name:com_content.article.3186)

Temps: 197.24 ms / 640.37 ms Mémoire: 2.398 MB / 32.28 MB Application: afterRenderComponent com_content

Temps: 0.84 ms / 641.21 ms Mémoire: 0.005 MB / 32.29 MB Application: afterDispatch

Temps: 6.79 ms / 648.00 ms Mémoire: 0.053 MB / 32.34 MB Application: beforeRenderModule mod_menu (Liens importants)

Temps: 4.11 ms / 652.11 ms Mémoire: 0.031 MB / 32.37 MB Application: afterRenderModule mod_menu (Liens importants)

Temps: 0.04 ms / 652.14 ms Mémoire: 0.000 MB / 32.37 MB Application: beforeRenderModule mod_flexi_customcode (Restez connecté)

Temps: 1.91 ms / 654.05 ms Mémoire: 0.012 MB / 32.38 MB Application: afterRenderModule mod_flexi_customcode (Restez connecté)

Temps: 0.05 ms / 654.10 ms Mémoire: 0.000 MB / 32.38 MB Application: beforeRenderModule mod_menu (Aide)

Temps: 2.44 ms / 656.54 ms Mémoire: 0.031 MB / 32.41 MB Application: afterRenderModule mod_menu (Aide)

Temps: 0.05 ms / 656.59 ms Mémoire: 0.000 MB / 32.41 MB Application: beforeRenderModule mod_flexi_customcode (logo PC)

Temps: 16.90 ms / 673.49 ms Mémoire: 0.005 MB / 32.41 MB Application: afterRenderModule mod_flexi_customcode (logo PC)

Temps: 0.10 ms / 673.59 ms Mémoire: 0.000 MB / 32.41 MB Application: beforeRenderModule mod_custom (Pub droite haut 300)

Temps: 1.61 ms / 675.19 ms Mémoire: 0.005 MB / 32.42 MB Application: afterRenderModule mod_custom (Pub droite haut 300)

Temps: 0.04 ms / 675.23 ms Mémoire: 0.000 MB / 32.42 MB Application: beforeRenderModule mod_flexi_customcode (Retrouvez Petit Citron sur)

Temps: 0.20 ms / 675.43 ms Mémoire: 0.005 MB / 32.42 MB Application: afterRenderModule mod_flexi_customcode (Retrouvez Petit Citron sur)

Temps: 0.02 ms / 675.45 ms Mémoire: 0.000 MB / 32.42 MB Application: beforeRenderModule mod_custom (lien vers livre (2))

Temps: 0.14 ms / 675.59 ms Mémoire: 0.002 MB / 32.42 MB Application: afterRenderModule mod_custom (lien vers livre (2))

Temps: 0.07 ms / 675.66 ms Mémoire: 0.000 MB / 32.42 MB Application: beforeRenderModule mod_custom (Pubs header)

Temps: 0.14 ms / 675.80 ms Mémoire: 0.002 MB / 32.42 MB Application: afterRenderModule mod_custom (Pubs header)

Temps: 0.04 ms / 675.84 ms Mémoire: 0.001 MB / 32.42 MB Application: beforeRenderModule mod_menu (menu top mobile)

Temps: 1.47 ms / 677.31 ms Mémoire: 0.032 MB / 32.46 MB Application: afterRenderModule mod_menu (menu top mobile)

Temps: 0.05 ms / 677.36 ms Mémoire: 0.000 MB / 32.45 MB Application: beforeRenderModule mod_menu (Menu top)

Temps: 0.90 ms / 678.25 ms Mémoire: 0.021 MB / 32.48 MB Application: afterRenderModule mod_menu (Menu top)

Temps: 0.05 ms / 678.30 ms Mémoire: 0.000 MB / 32.47 MB Application: beforeRenderModule mod_custom (Login / inscription)

Temps: 0.14 ms / 678.44 ms Mémoire: 0.002 MB / 32.48 MB Application: afterRenderModule mod_custom (Login / inscription)

Temps: 0.05 ms / 678.49 ms Mémoire: 0.000 MB / 32.48 MB Application: beforeRenderModule mod_search (Recherche)

Temps: 0.95 ms / 679.44 ms Mémoire: 0.014 MB / 32.49 MB Application: afterRenderModule mod_search (Recherche)

Temps: 11.01 ms / 690.45 ms Mémoire: 0.049 MB / 32.54 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

61 requêtes exécutées 403.28 ms

8 doubles découverts!

2 requêtes dupliquées: #27 #47

4 requêtes dupliquées: #41 #53 #57 #58

2 requêtes dupliquées: #55 #56

Temps de requête : 0.73 ms Mémoire de requête : 0.022 MB mémoire avant requête : 0.885 MB Rangées retournées : 0

SELECT `data`

  FROM `pc38_session`

  WHERE `session_id` = '81513f266b51d97dd7a37031cf7f352a'

Explication

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

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

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

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

SELECT `session_id`

  FROM `pc38_session`

  WHERE `session_id` = '81513f266b51d97dd7a37031cf7f352a' 
  LIMIT 1

Explication

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	24.84 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Pile d'appels

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

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

Temps de requête : 2.18 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.003 MB mémoire avant requête : 0.901 MB

INSERT INTO `pc38_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('81513f266b51d97dd7a37031cf7f352a', 1, 1550891844, 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `pc38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('81513f266b51d97dd7a37031cf7f352a', 1, 1550891844, 0, '', 0)

Profil

Status	Duration
starting	0.03 ms
Opening tables	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de requête : 0.71 ms Après la dernière requête : 1.19 ms Mémoire de requête : 0.028 MB mémoire avant requête : 0.991 MB Rangées retournées : 46

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

  FROM `pc38_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	pc38_extensions	ref	extension	extension	82	const	46	Using where

Profil

Status	Duration
starting	0.02 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.20 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id, rules

  FROM `pc38_viewlevels`

Explication

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

Profil

Status	Duration
starting	0.02 ms
Opening tables	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

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

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

Temps de requête : 0.35 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.032 MB Rangées retournées : 2

SELECT b.id

  FROM pc38_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.08 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

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

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

Temps de requête : 1.97 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.052 MB mémoire avant requête : 1.052 MB Rangées retournées : 197

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

  FROM pc38_extensions

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

  ORDER BY ordering

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.20 ms
Sending data	0.91 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.15 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
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:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT extension_id 
  FROM pc38_extensions 
  WHERE type = "component" 
  AND element = "com_cck_webservices"

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/cms/cck/database.php:131
12	JCckDatabase::loadResult()	JROOT/libraries/cms/cck/database/cache.php:64
11	JCckDatabaseCache::loadResult()	JROOT/libraries/cms/cck/webservice.php:28
10	JCckWebservice::_setConfig()	JROOT/libraries/cms/cck/webservice.php:45
9	JCckWebservice::getConfig()	JROOT/plugins/system/cck/cck.php:958
8	plgSystemCCK->_isRestApi()	JROOT/plugins/system/cck/cck.php:47
7	plgSystemCCK->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 92.17 ms Après la dernière requête : 6.42 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.664 MB

UPDATE pc38_redirectonlogin_sessions 
  SET session_id='81513f266b51d97dd7a37031cf7f352a', unixtime='1550891844' 
  WHERE session_id='adopt_me'

Explication

EXPLAIN impossible sur la requête : UPDATE pc38_redirectonlogin_sessions SET session_id='81513f266b51d97dd7a37031cf7f352a', unixtime='1550891844' WHERE session_id='adopt_me'

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
update	0.06 ms
Waiting for query cache lock	0.00 ms
update	0.01 ms
end	0.00 ms
query end	1.86 ms
closing tables	0.01 ms
freeing items	0.05 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:120
8	plgSystemRedirectonlogin->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *  
  FROM pc38_redirectonlogin_sessions  
  WHERE session_id='81513f266b51d97dd7a37031cf7f352a'  
  LIMIT 1

Explication

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
System lock	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.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.06 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:128
8	plgSystemRedirectonlogin->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *  
  FROM pc38_redirectonlogin_sessions  
  WHERE session_id='adopt_me'  
  AND ip='54.146.227.92'  
  LIMIT 1

Explication

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.05 ms
Updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.03 ms
query end	1.40 ms
closing tables	0.01 ms
freeing items	0.06 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:155
8	plgSystemRedirectonlogin->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.65 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.003 MB mémoire avant requête : 1.675 MB

INSERT INTO pc38_redirectonlogin_sessions 
  SET session_id='81513f266b51d97dd7a37031cf7f352a', unixtime='1550891844'

Explication

EXPLAIN impossible sur la requête : INSERT INTO pc38_redirectonlogin_sessions SET session_id='81513f266b51d97dd7a37031cf7f352a', unixtime='1550891844'

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.08 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:174
8	plgSystemRedirectonlogin->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.55 ms Après la dernière requête : 1.06 ms Mémoire de requête : 0.032 MB mémoire avant requête : 1.771 MB Rangées retournées : 92

SELECT *

  FROM pc38_j2store_configurations

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.06 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.47 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.09 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/helpers/config.php:20
12	J2Config->__construct()	JROOT/administrator/components/com_j2store/helpers/config.php:28
11	J2Config::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:72
10	J2Store::config()	JROOT/plugins/system/j2store/j2store.php:165
9	plgSystemJ2Store->onJ2StoreCronTask()	JROOT/plugins/system/j2store/j2store.php:145
8	plgSystemJ2Store->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.49 ms Après la dernière requête : 0.68 ms Mémoire de requête : 0.070 MB mémoire avant requête : 1.840 MB Rangées retournées : 61

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

  LEFT JOIN pc38_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	72	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	petitcitrondb6.m.component_id	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/cck/cck.php:227
8	plgSystemCCK->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT extension_id 
  FROM pc38_extensions 
  WHERE type = "component" 
  AND element = "com_cck_toolbox"

Explication

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

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	60.10 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.13 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/cms/cck/database.php:131
11	JCckDatabase::loadResult()	JROOT/libraries/cms/cck/database/cache.php:64
10	JCckDatabaseCache::loadResult()	JROOT/libraries/cms/cck/toolbox.php:26
9	JCckToolbox::getConfig()	JROOT/plugins/system/cck/cck.php:255
8	plgSystemCCK->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT type, scriptfile, options 
  FROM pc38_cck_more_processings 
  WHERE published = 1 
  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_cck_more_processings	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	4	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
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/cck/database.php:108
11	JCckDatabase::loadObjectListArray()	JROOT/libraries/cms/cck/database/cache.php:51
10	JCckDatabaseCache::loadObjectListArray()	JROOT/libraries/cms/cck/toolbox.php:256
9	JCckToolbox::process()	JROOT/plugins/system/cck/cck.php:256
8	plgSystemCCK->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.44 ms Après la dernière requête : 14.81 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.156 MB Rangées retournées : 1

SELECT options, sef_route, sef_route_aliases, storage_location 
  FROM pc38_cck_core_searchs 
  WHERE name = 'lexique'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_cck_core_searchs	const	name	name	202	const	1

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	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.17 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/libraries/cms/cck/database.php:85
11	JCckDatabase::loadObject()	JROOT/libraries/cms/cck/dev/helper.php:456
10	JCckDevHelper::getRouteParams()	JROOT/components/com_cck/router.php:107
9	CckRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.id 
  FROM pc38_content AS a 
  LEFT JOIN pc38_categories AS b 
  on b.id = a.catid 
  WHERE a.alias = 'bouton-de-passementerie' 
  AND b.alias = 'materiel-fournitures'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_catid,idx_alias	idx_alias	766	const	1	Using where
1	SIMPLE	b	eq_ref	PRIMARY,idx_alias	PRIMARY	4	petitcitrondb6.a.catid	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/libraries/cms/cck/database.php:131
13	JCckDatabase::loadResult()	JROOT/libraries/cms/cck/database/cache.php:64
12	JCckDatabaseCache::loadResult()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:965
11	plgCCK_Storage_LocationJoomla_Article::parseRoute()	JROOT/libraries/cms/cck/cck.php:32
10	JCck::callFunc_Array()	JROOT/components/com_cck/router.php:153
9	CckRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `pc38_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
18	JDatabaseDriver->loadObject()	JROOT/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/j2store/j2store.php:80
8	plgSystemJ2Store->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.90 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.004 MB mémoire avant requête : 2.176 MB

UPDATE `pc38_extensions`

  SET `params` = '{\"mediaversion\":\"4004efba35090aca36cf243bed6f81e8\"}'

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

Explication

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.09 ms
logging slow query	0.01 ms
cleaning up	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/j2store/j2store.php:80
8	plgSystemJ2Store->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT COUNT(*) 
  FROM pc38_rantispam_banip 
  WHERE bannedip = '54.146.227.92'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/rantispam/rantispam.php:87
9	plgSystemRAntiSpam->checkBanned()	JROOT/plugins/system/rantispam/rantispam.php:121
8	plgSystemRAntiSpam->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 8.11 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.026 MB mémoire avant requête : 2.199 MB Rangées retournées : 42

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

  FROM `pc38_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_cck','com_cck_developer','com_cck_importer','com_cck_updater','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_hashcheck','com_installer','com_j2store','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_rantispam','com_redirect','com_redirectonlogin','com_search','com_tags','com_templates','com_users','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_assets	range	idx_asset_name	idx_asset_name	202	NULL	45	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/rantispam/rantispam.php:110
9	plgSystemRAntiSpam->canSubmitAnything()	JROOT/plugins/system/rantispam/rantispam.php:123
8	plgSystemRAntiSpam->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM pc38_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 11.27 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.069 MB mémoire avant requête : 2.262 MB Rangées retournées : 123

SELECT id, home, template, s.params

  FROM pc38_template_styles as s

  LEFT JOIN pc38_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	15	Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	petitcitrondb6.e.element	4	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 128.47 ms Après la dernière requête : 5.20 ms Mémoire de requête : 6.071 MB mémoire avant requête : 2.313 MB Rangées retournées : 51214

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

  FROM `pc38_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 9.89 ms Après la dernière requête : 79.24 ms Mémoire de requête : 0.032 MB mémoire avant requête : 29.886 MB Rangées retournées : 32

SHOW FULL COLUMNS 
  FROM `pc38_content`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #47

SELECT *

  FROM pc38_content

  WHERE `id` = '3186'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 5.44 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.004 MB mémoire avant requête : 30.014 MB

UPDATE pc38_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '3186'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM pc38_content AS a

  INNER JOIN pc38_categories AS c 
  on c.id = a.catid

  LEFT JOIN pc38_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 3186 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-23 03:17:25') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-23 03:17:25') 
  AND (a.state = 1 OR a.state =2)

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.93 ms Après la dernière requête : 0.89 ms Mémoire de requête : 0.031 MB mémoire avant requête : 30.064 MB Rangées retournées : 3

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 `pc38_categories` AS `s`

  INNER JOIN `pc38_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,5) 
  AND c.published = 1 
  AND s.id = 26

  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	Utilisation du tri complet de type filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	43	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `pc38_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 3186 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM `pc38_kunena_configuration`

  WHERE `id`=1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_kunena_configuration	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1400
17	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1373
16	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:237
15	KunenaFactory::getConfig()	JROOT/libraries/kunena/forum/forum.php:119
14	KunenaForum::enabled()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:106
13	plgContentKunenaDiscuss->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 11.10 ms Après la dernière requête : 3.25 ms Mémoire de requête : 0.038 MB mémoire avant requête : 30.438 MB Rangées retournées : 56

SHOW FULL COLUMNS 
  FROM `pc38_kunena_users`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
25	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:445
24	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:312
23	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:231
22	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:190
21	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:165
20	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:91
19	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
18	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:738
17	JLoader::_load()	JROOT/libraries/loader.php:707
16	JLoader::_autoload()	Même appel que celui de la ligne ci-dessous.
15	spl_autoload_call()	JROOT/libraries/kunena/factory.php:83
14	KunenaFactory::getUser()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:112
13	plgContentKunenaDiscuss->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM pc38_fields AS a

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

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

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

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

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

  LEFT JOIN `pc38_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (26,0,22)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.00 ms
init	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
checking permissions	1.75 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.70 ms Après la dernière requête : 10.10 ms Mémoire de requête : 0.047 MB mémoire avant requête : 30.898 MB Rangées retournées : 565

SHOW TABLES

Explication

EXPLAIN impossible sur la requête : SHOW TABLES

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
21	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
20	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
19	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2082
18	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:87
14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:65
13	plgContentJ2Store->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SHOW FULL COLUMNS 
  FROM `pc38_j2store_products`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
19	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
18	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:87
14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:65
13	plgContentJ2Store->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.83 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.027 MB mémoire avant requête : 30.997 MB Rangées retournées : 8

SHOW FULL COLUMNS 
  FROM `pc38_j2store_productimages`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
18	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:87
14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:65
13	plgContentJ2Store->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.02 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.027 MB mémoire avant requête : 31.014 MB Rangées retournées : 5

SHOW FULL COLUMNS 
  FROM `pc38_j2store_manufacturers`

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.05 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
18	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:87
14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:65
13	plgContentJ2Store->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SHOW FULL COLUMNS 
  FROM `pc38_j2store_vendors`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
18	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:87
14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:65
13	plgContentJ2Store->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.64 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.029 MB mémoire avant requête : 31.041 MB Rangées retournées : 18

SHOW FULL COLUMNS 
  FROM `pc38_j2store_addresses`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
18	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:87
14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:65
13	plgContentJ2Store->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.84 ms Après la dernière requête : 2.33 ms Mémoire de requête : 0.031 MB mémoire avant requête : 31.091 MB Rangées retournées : 0

Requêtes dupliquées: #53 #57 #58

SELECT pc38_j2store_products.*,`pc38_j2store_productimages`.`j2store_productimage_id`,`pc38_j2store_productimages`.`main_image`,`pc38_j2store_productimages`.`main_image_alt`,`pc38_j2store_productimages`.`thumb_image`,`pc38_j2store_productimages`.`thumb_image_alt`,`pc38_j2store_productimages`.`additional_images`,`pc38_j2store_productimages`.`additional_images_alt`,`pc38_j2store_manufacturers`.`brand_desc_id`,`pc38_j2store_addresses`.`first_name` AS manufacturer_first_name,`pc38_j2store_addresses`.`last_name` AS manufacturer_last_name,`pc38_j2store_addresses`.`company` AS manufacturer

  FROM pc38_j2store_products

  LEFT JOIN `pc38_j2store_productimages` 
  ON `pc38_j2store_products`.`j2store_product_id` = `pc38_j2store_productimages`.`product_id`

  LEFT JOIN `pc38_j2store_manufacturers` 
  ON `pc38_j2store_products`.`manufacturer_id` = `pc38_j2store_manufacturers`.`j2store_manufacturer_id`

  LEFT JOIN `pc38_j2store_vendors` 
  ON `pc38_j2store_products`.`vendor_id` = `pc38_j2store_vendors`.`j2store_vendor_id`

  LEFT JOIN `pc38_j2store_addresses` 
  ON `pc38_j2store_manufacturers`.`address_id` = `pc38_j2store_addresses`.`j2store_address_id`

  WHERE `pc38_j2store_products`.`product_source` = 'com_content' 
  AND `pc38_j2store_products`.`product_source_id` = '3186' 
  AND `pc38_j2store_products`.`enabled` = '1' 
  AND `pc38_j2store_products`.`visibility` = '1'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
18	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
17	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:94
16	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/tables/product.php:197
15	J2StoreTableProduct->get_product_by_source()	JROOT/plugins/content/j2store/j2store.php:89
14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:65
13	plgContentJ2Store->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.id, a.pk, a.pkb, a.cck, a.storage_location, a.store_id, a.author_id AS author, b.id AS type_id, b.alias AS type_alias, b.indexed, b.parent, b.parent_inherit, b.stylesheets, b.options_content, b.options_intro, c.template AS content_template, c.params AS content_params, d.template AS intro_template, d.params AS intro_params, f.app as folder_app 
  FROM pc38_cck_core AS a 
  LEFT JOIN pc38_cck_core_types AS b 
  ON b.name = a.cck 
  LEFT JOIN pc38_template_styles AS c 
  ON c.id = b.template_content 
  LEFT JOIN pc38_template_styles AS d 
  ON d.id = b.template_intro 
  LEFT JOIN pc38_cck_core_folders AS f 
  ON f.id = b.folder 
  WHERE a.id = "3219"

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	const	name	name	202	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	d	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	f	const	PRIMARY	PRIMARY	4	const	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/libraries/cms/cck/database.php:85
15	JCckDatabase::loadObject()	JROOT/plugins/content/cck/cck.php:292
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.05 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.045 MB mémoire avant requête : 31.097 MB Rangées retournées : 7

SELECT cc.*, c.ordering, c.label as label2, c.variation, c.link, c.link_options, c.markup, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.restriction, c.restriction_options, c.position 
  FROM pc38_cck_core_type_field AS c 
  LEFT JOIN pc38_cck_core_types AS sc 
  ON sc.id = c.typeid 
  LEFT JOIN pc38_cck_core_fields AS cc 
  ON cc.id = c.fieldid 
  WHERE sc.name = "terme" 
  AND sc.published = 1 
  AND c.client = "content" 
  AND c.access IN (1,1,5) 
  ORDER BY c.ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sc	const	PRIMARY,name	name	202	const	1	Utilisation du tri complet de type filesort
1	SIMPLE	c	ref	PRIMARY,typeid	PRIMARY	4	const	16	Using where
1	SIMPLE	cc	eq_ref	PRIMARY	PRIMARY	4	petitcitrondb6.c.fieldid	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/cck/database.php:96
15	JCckDatabase::loadObjectList()	JROOT/plugins/content/cck/cck.php:367
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.37 ms Après la dernière requête : 42.62 ms Mémoire de requête : 0.033 MB mémoire avant requête : 31.761 MB Rangées retournées : 2

SELECT * 
  FROM pc38_cck_core_type_position AS a 
  LEFT JOIN pc38_cck_core_types AS b 
  ON b.id = a.typeid 
  WHERE b.name = "terme" 
  AND a.client ="content"

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	const	PRIMARY,name	name	202	const	1
1	SIMPLE	a	ref	PRIMARY,typeid	PRIMARY	4	const	6	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/cck/database.php:96
16	JCckDatabase::loadObjectList()	JROOT/plugins/content/cck/cck.php:508
15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:439
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 5.10 ms Après la dernière requête : 2.34 ms Mémoire de requête : 0.027 MB mémoire avant requête : 31.810 MB Rangées retournées : 3

SHOW FULL COLUMNS 
  FROM `pc38_cck_store_form_terme`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/cms/cck/table.php:23
23	JCckTablePlaceholder->getFields()	JROOT/libraries/src/Table/Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/cms/cck/table.php:65
21	JCckTable->__construct()	JROOT/libraries/cms/cck/table.php:77
20	JCckTable::getInstance()	JROOT/libraries/cms/cck/plugin/location.php:259
19	JCckPluginLocation->g_onCCK_Storage_LocationPrepareContent()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:99
18	plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/plugins/content/cck/cck.php:541
15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:439
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM pc38_cck_store_form_terme

  WHERE `id` = '3186'

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.80 ms
Sending data	0.73 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
21	Joomla\CMS\Table\Table->load()	JROOT/libraries/cms/cck/table.php:88
20	JCckTable->load()	JROOT/libraries/cms/cck/plugin/location.php:262
19	JCckPluginLocation->g_onCCK_Storage_LocationPrepareContent()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:99
18	plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/plugins/content/cck/cck.php:541
15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:439
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #27

SELECT *

  FROM pc38_content

  WHERE `id` = '3186'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
20	Joomla\CMS\Table\Table->load()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:469
19	plgCCK_Storage_LocationJoomla_Article::_getTable()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:101
18	plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/plugins/content/cck/cck.php:541
15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:439
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.title AS category_title, b.alias AS category_alias 
  FROM pc38_content AS a 
  LEFT JOIN pc38_categories AS b 
  ON b.id = a.catid 
  WHERE a.id = 3186

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	const	PRIMARY	PRIMARY	4	const	1

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
22	JDatabaseDriver->loadObject()	JROOT/libraries/cms/cck/database.php:85
21	JCckDatabase::loadObject()	JROOT/libraries/cms/cck/database/cache.php:25
20	JCckDatabaseCache::loadObject()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:497
19	plgCCK_Storage_LocationJoomla_Article::_getTable()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:101
18	plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/plugins/content/cck/cck.php:541
15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:439
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `t`.`id`

  FROM `pc38_tags` AS t 

  INNER JOIN `pc38_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` IN ( 3186)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	index	PRIMARY	idx_access	4	NULL	1	Using index
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	petitcitrondb6.t.id	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
21	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Helper/TagsHelper.php:506
20	Joomla\CMS\Helper\TagsHelper->getTagIds()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:522
19	plgCCK_Storage_LocationJoomla_Article::_getTable()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:101
18	plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/plugins/content/cck/cck.php:541
15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:439
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.94 ms Après la dernière requête : 0.72 ms Mémoire de requête : 0.031 MB mémoire avant requête : 31.932 MB Rangées retournées : 27

SHOW FULL COLUMNS 
  FROM `pc38_categories`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Category.php:35
21	Joomla\CMS\Table\Category->__construct()	JROOT/libraries/src/Table/Table.php:312
20	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/cck_storage_location/joomla_category/joomla_category.php:439
19	plgCCK_Storage_LocationJoomla_Category::_getTable()	JROOT/plugins/cck_storage_location/joomla_category/joomla_category.php:92
18	plgCCK_Storage_LocationJoomla_Category->onCCK_Storage_LocationPrepareContent()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/plugins/content/cck/cck.php:541
15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:439
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM pc38_categories

  WHERE `id` = '3186'

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
Opening tables	0.04 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.19 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
20	Joomla\CMS\Table\Table->load()	JROOT/plugins/cck_storage_location/joomla_category/joomla_category.php:442
19	plgCCK_Storage_LocationJoomla_Category::_getTable()	JROOT/plugins/cck_storage_location/joomla_category/joomla_category.php:92
18	plgCCK_Storage_LocationJoomla_Category->onCCK_Storage_LocationPrepareContent()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/plugins/content/cck/cck.php:541
15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:439
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT title,id 
  FROM pc38_categories 
  WHERE parent_id=22 
  and published=1 
  ORDER BY title ASC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/cck/database.php:96
21	JCckDatabase::loadObjectList()	JROOT/libraries/cms/cck/database/cache.php:38
20	JCckDatabaseCache::loadObjectList()	JROOT/plugins/cck_field/select_dynamic/select_dynamic.php:727
19	plgCCK_FieldSelect_Dynamic::_getOptionsList()	JROOT/plugins/cck_field/select_dynamic/select_dynamic.php:124
18	plgCCK_FieldSelect_Dynamic->onCCK_FieldPrepareContent()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/plugins/content/cck/cck.php:550
15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:439
14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:269
13	plgContentCCK->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.67 ms Après la dernière requête : 6.38 ms Mémoire de requête : 0.031 MB mémoire avant requête : 32.030 MB Rangées retournées : 0

Requêtes dupliquées: #41 #57 #58

SELECT pc38_j2store_products.*,`pc38_j2store_productimages`.`j2store_productimage_id`,`pc38_j2store_productimages`.`main_image`,`pc38_j2store_productimages`.`main_image_alt`,`pc38_j2store_productimages`.`thumb_image`,`pc38_j2store_productimages`.`thumb_image_alt`,`pc38_j2store_productimages`.`additional_images`,`pc38_j2store_productimages`.`additional_images_alt`,`pc38_j2store_manufacturers`.`brand_desc_id`,`pc38_j2store_addresses`.`first_name` AS manufacturer_first_name,`pc38_j2store_addresses`.`last_name` AS manufacturer_last_name,`pc38_j2store_addresses`.`company` AS manufacturer

  FROM pc38_j2store_products

  LEFT JOIN `pc38_j2store_productimages` 
  ON `pc38_j2store_products`.`j2store_product_id` = `pc38_j2store_productimages`.`product_id`

  LEFT JOIN `pc38_j2store_manufacturers` 
  ON `pc38_j2store_products`.`manufacturer_id` = `pc38_j2store_manufacturers`.`j2store_manufacturer_id`

  LEFT JOIN `pc38_j2store_vendors` 
  ON `pc38_j2store_products`.`vendor_id` = `pc38_j2store_vendors`.`j2store_vendor_id`

  LEFT JOIN `pc38_j2store_addresses` 
  ON `pc38_j2store_manufacturers`.`address_id` = `pc38_j2store_addresses`.`j2store_address_id`

  WHERE `pc38_j2store_products`.`product_source` = 'com_content' 
  AND `pc38_j2store_products`.`product_source_id` = '3186' 
  AND `pc38_j2store_products`.`enabled` = '1' 
  AND `pc38_j2store_products`.`visibility` = '1'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
17	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
16	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:94
15	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/tables/product.php:197
14	J2StoreTableProduct->get_product_by_source()	JROOT/plugins/j2store/app_socialmedia/app_socialmedia.php:209
13	plgJ2StoreApp_socialmedia->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:196
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.74 ms Après la dernière requête : 5.95 ms Mémoire de requête : 0.022 MB mémoire avant requête : 32.219 MB Rangées retournées : 1

SHOW TABLES LIKE 'pc38_kunenadiscuss'

Explication

EXPLAIN impossible sur la requête : SHOW TABLES LIKE 'pc38_kunenadiscuss'

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:211
14	plgContentKunenaDiscuss->createTable()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:180
13	plgContentKunenaDiscuss->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #56

SELECT `parent_id`

  FROM pc38_categories

  WHERE id = '26'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:538
15	plgContentKunenaDiscuss->getForumCategory()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:299
14	plgContentKunenaDiscuss->prepare()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:190
13	plgContentKunenaDiscuss->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #55

SELECT `parent_id`

  FROM pc38_categories

  WHERE id = '26'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:546
15	plgContentKunenaDiscuss->getForumCategory()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:299
14	plgContentKunenaDiscuss->prepare()	JROOT/plugins/content/kunenadiscuss/kunenadiscuss.php:190
13	plgContentKunenaDiscuss->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #41 #53 #58

SELECT pc38_j2store_products.*,`pc38_j2store_productimages`.`j2store_productimage_id`,`pc38_j2store_productimages`.`main_image`,`pc38_j2store_productimages`.`main_image_alt`,`pc38_j2store_productimages`.`thumb_image`,`pc38_j2store_productimages`.`thumb_image_alt`,`pc38_j2store_productimages`.`additional_images`,`pc38_j2store_productimages`.`additional_images_alt`,`pc38_j2store_manufacturers`.`brand_desc_id`,`pc38_j2store_addresses`.`first_name` AS manufacturer_first_name,`pc38_j2store_addresses`.`last_name` AS manufacturer_last_name,`pc38_j2store_addresses`.`company` AS manufacturer

  FROM pc38_j2store_products

  LEFT JOIN `pc38_j2store_productimages` 
  ON `pc38_j2store_products`.`j2store_product_id` = `pc38_j2store_productimages`.`product_id`

  LEFT JOIN `pc38_j2store_manufacturers` 
  ON `pc38_j2store_products`.`manufacturer_id` = `pc38_j2store_manufacturers`.`j2store_manufacturer_id`

  LEFT JOIN `pc38_j2store_vendors` 
  ON `pc38_j2store_products`.`vendor_id` = `pc38_j2store_vendors`.`j2store_vendor_id`

  LEFT JOIN `pc38_j2store_addresses` 
  ON `pc38_j2store_manufacturers`.`address_id` = `pc38_j2store_addresses`.`j2store_address_id`

  WHERE `pc38_j2store_products`.`product_source` = 'com_content' 
  AND `pc38_j2store_products`.`product_source_id` = '3186' 
  AND `pc38_j2store_products`.`enabled` = '1' 
  AND `pc38_j2store_products`.`visibility` = '1'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
17	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
16	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:94
15	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/tables/product.php:197
14	J2StoreTableProduct->get_product_by_source()	JROOT/plugins/j2store/app_socialmedia/app_socialmedia.php:224
13	plgJ2StoreApp_socialmedia->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.74 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.031 MB mémoire avant requête : 32.277 MB Rangées retournées : 0

Requêtes dupliquées: #41 #53 #57

SELECT pc38_j2store_products.*,`pc38_j2store_productimages`.`j2store_productimage_id`,`pc38_j2store_productimages`.`main_image`,`pc38_j2store_productimages`.`main_image_alt`,`pc38_j2store_productimages`.`thumb_image`,`pc38_j2store_productimages`.`thumb_image_alt`,`pc38_j2store_productimages`.`additional_images`,`pc38_j2store_productimages`.`additional_images_alt`,`pc38_j2store_manufacturers`.`brand_desc_id`,`pc38_j2store_addresses`.`first_name` AS manufacturer_first_name,`pc38_j2store_addresses`.`last_name` AS manufacturer_last_name,`pc38_j2store_addresses`.`company` AS manufacturer

  FROM pc38_j2store_products

  LEFT JOIN `pc38_j2store_productimages` 
  ON `pc38_j2store_products`.`j2store_product_id` = `pc38_j2store_productimages`.`product_id`

  LEFT JOIN `pc38_j2store_manufacturers` 
  ON `pc38_j2store_products`.`manufacturer_id` = `pc38_j2store_manufacturers`.`j2store_manufacturer_id`

  LEFT JOIN `pc38_j2store_vendors` 
  ON `pc38_j2store_products`.`vendor_id` = `pc38_j2store_vendors`.`j2store_vendor_id`

  LEFT JOIN `pc38_j2store_addresses` 
  ON `pc38_j2store_manufacturers`.`address_id` = `pc38_j2store_addresses`.`j2store_address_id`

  WHERE `pc38_j2store_products`.`product_source` = 'com_content' 
  AND `pc38_j2store_products`.`product_source_id` = '3186' 
  AND `pc38_j2store_products`.`enabled` = '1' 
  AND `pc38_j2store_products`.`visibility` = '1'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
17	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
16	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:94
15	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/tables/product.php:197
14	J2StoreTableProduct->get_product_by_source()	JROOT/plugins/j2store/app_socialmedia/app_socialmedia.php:239
13	plgJ2StoreApp_socialmedia->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.06 ms Après la dernière requête : 4.99 ms Mémoire de requête : 0.092 MB mémoire avant requête : 32.325 MB Rangées retournées : 131

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

  FROM pc38_modules AS m

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

  LEFT JOIN pc38_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 <= '2019-02-23 03:17:25') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-23 03:17:25') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 105 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	ref	PRIMARY,published,newsfeeds	published	1	const	28	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	petitcitrondb6.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	petitcitrondb6.m.module,const	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:125
7	require JROOT/templates/protostar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src