Le label Bas-Carbone s’appuie sur un référentiel réécrit

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1686152398,
                "last": 1686152398,
                "now": 1686152398
            },
            "token": "ugSI3jgnooeabsa9zSvp4BvataquQVGI"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "fr-FR"
        },
        "osm_return_url": "https://www.forestopic.com/fr/en-bref/1382-label-bas-carbone-referentiel-reecrit",
        "required_plan_ids": [
            "59",
            "17",
            "3",
            "18",
            "22",
            "2",
            "41",
            "61"
        ]
    }
}

Temps

Mémoire

113 requêtes exécutées 57.24 ms

1. Temps de requête : 0.15 ms Mémoire de requête : 0.023 MB mémoire avant requête : 0.817 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `qrsm4_session`
   
     WHERE `session_id` = X'746a65396533637068336771693230636e636f356c366264676c'

   Explication

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

   Profil

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

   Pile d'appels

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Temps de requête : 0.12 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.020 MB mémoire avant requête : 0.829 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `qrsm4_session`
   
     WHERE `session_id` = X'746a65396533637068336771693230636e636f356c366264676c' 
     LIMIT 1

   Explication

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

   Profil

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

   Pile d'appels

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

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

   ---

3. Temps de requête : 0.42 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.004 MB mémoire avant requête : 0.834 MB

   INSERT INTO `qrsm4_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'746a65396533637068336771693230636e636f356c366264676c', 1, 1686152398, 0, '', 0)

   Explication

   EXPLAIN impossible sur la requête : INSERT INTO `qrsm4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'746a65396533637068336771693230636e636f356c366264676c', 1, 1686152398, 0, '', 0)

   Profil

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

   Pile d'appels

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Temps de requête : 0.18 ms Après la dernière requête : 1.32 ms Mémoire de requête : 0.021 MB mémoire avant requête : 0.919 MB Rangées retournées : 12

   SELECT id, rules
   
     FROM `qrsm4_viewlevels`

   Explication

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

   Profil

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

   Pile d'appels

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

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

   ---

5. Temps de requête : 0.23 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.021 MB mémoire avant requête : 0.934 MB Rangées retournées : 2

   SELECT b.id
   
     FROM qrsm4_usergroups AS a
   
     LEFT JOIN qrsm4_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	7	Using where; Using index

   Profil

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

   Pile d'appels

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

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

   ---

6. Temps de requête : 0.20 ms Après la dernière requête : 5.08 ms Mémoire de requête : 0.022 MB mémoire avant requête : 1.309 MB Rangées retournées : 1

   SELECT `value`
   
     FROM `qrsm4_admintools_storage`
   
     WHERE `key` = 'cparams'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qrsm4_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

   Profil

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

   Pile d'appels

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
   12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
   11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
   10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
   9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Temps de requête : 0.18 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.317 MB Rangées retournées : 0

   SELECT *
   
     FROM `qrsm4_admintools_wafexceptions`
   
     WHERE NOT(`option` LIKE 'com_%')

   Explication

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

   Profil

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

   Pile d'appels

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Temps de requête : 0.22 ms Après la dernière requête : 4.57 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.712 MB

   UPDATE qrsm4_extensions
   
     SET enabled=1
   
     WHERE `type`='plugin' 
     AND `element`='jacontenttype' 
     AND `folder`='ajax'

   Explication

   EXPLAIN impossible sur la requête : UPDATE qrsm4_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'

   Profil

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

   Pile d'appels

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/jacontenttype/jacontenttype.php:62
   8	PlgSystemJacontenttype->_check()	JROOT/plugins/system/jacontenttype/jacontenttype.php:44
   7	PlgSystemJacontenttype->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Temps de requête : 0.24 ms Après la dernière requête : 4.07 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.763 MB Rangées retournées : 0

   SELECT `source`,`keepurlparams`
   
     FROM `qrsm4_admintools_redirects`
   
     WHERE ((`dest` = 'fr/en-bref/1382-label-bas-carbone-referentiel-reecrit') OR (`dest` = 'fr/en-bref/1382-label-bas-carbone-referentiel-reecrit') OR ('fr/en-bref/1382-label-bas-carbone-referentiel-reecrit' LIKE `dest`)) 
     AND `published` = '1'
   
     ORDER BY `ordering` DESC 
     LIMIT 1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qrsm4_admintools_redirects	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	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

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
   11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
   10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
   9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
   8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Temps de requête : 0.86 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.029 MB mémoire avant requête : 1.766 MB Rangées retournées : 312
    Requêtes dupliquées: #36

    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

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
    9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/acyctriggers/acyctriggers.php:92
    8	plgSystemAcyctriggers->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Temps de requête : 0.20 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.771 MB Rangées retournées : 1

    SELECT `value` 
      FROM qrsm4_acyc_configuration 
      WHERE `name` = "license_key"

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qrsm4_acyc_configuration	const	PRIMARY	PRIMARY	767	const	1

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/acyctriggers/acyctriggers.php:97
    8	plgSystemAcyctriggers->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Temps de requête : 0.16 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.776 MB Rangées retournées : 0

    SELECT `value` 
      FROM qrsm4_acyc_configuration 
      WHERE `name` = "last_cron_trigger"

    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

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/acyctriggers/acyctriggers.php:102
    8	plgSystemAcyctriggers->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Temps de requête : 0.17 ms Après la dernière requête : 1.07 ms Mémoire de requête : 0.024 MB mémoire avant requête : 1.810 MB Rangées retournées : 23
    Requêtes dupliquées: #14

    SELECT * 
      FROM qrsm4_acyc_configuration

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acychecker/cms/cmsServices/Database.php:42
    16	AcyCheckerCmsServices\Database::loadObjectList()	JROOT/administrator/components/com_acychecker/src/Classes/ConfigurationClass.php:23
    15	AcyChecker\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acychecker/src/Libraries/AcycObject.php:30
    14	AcyChecker\Libraries\AcycObject->getConfiguration()	JROOT/administrator/components/com_acychecker/src/Libraries/AcycObject.php:22
    13	AcyChecker\Libraries\AcycObject->__construct()	JROOT/administrator/components/com_acychecker/src/Libraries/AcycObject.php:29
    12	AcyChecker\Libraries\AcycObject->getConfiguration()	JROOT/administrator/components/com_acychecker/src/Libraries/AcycObject.php:22
    11	AcyChecker\Libraries\AcycObject->__construct()	JROOT/administrator/components/com_acychecker/src/Services/CronService.php:47
    10	AcyChecker\Services\CronService->__construct()	JROOT/plugins/system/acyctriggers/acyctriggers.php:113
    9	plgSystemAcyctriggers->processCron()	JROOT/plugins/system/acyctriggers/acyctriggers.php:107
    8	plgSystemAcyctriggers->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Temps de requête : 0.20 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.833 MB Rangées retournées : 23
    Requêtes dupliquées: #13

    SELECT * 
      FROM qrsm4_acyc_configuration

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acychecker/cms/cmsServices/Database.php:42
    14	AcyCheckerCmsServices\Database::loadObjectList()	JROOT/administrator/components/com_acychecker/src/Classes/ConfigurationClass.php:23
    13	AcyChecker\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acychecker/src/Libraries/AcycObject.php:30
    12	AcyChecker\Libraries\AcycObject->getConfiguration()	JROOT/administrator/components/com_acychecker/src/Libraries/AcycObject.php:22
    11	AcyChecker\Libraries\AcycObject->__construct()	JROOT/administrator/components/com_acychecker/src/Services/CronService.php:47
    10	AcyChecker\Services\CronService->__construct()	JROOT/plugins/system/acyctriggers/acyctriggers.php:113
    9	plgSystemAcyctriggers->processCron()	JROOT/plugins/system/acyctriggers/acyctriggers.php:107
    8	plgSystemAcyctriggers->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Temps de requête : 0.35 ms Après la dernière requête : 13.96 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.177 MB Rangées retournées : 0

    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 `qrsm4_categories` AS `s`
    
      INNER JOIN `qrsm4_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('fr-FR','*')) 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 = 1382
    
      ORDER BY c.lft

    Explication

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

    Profil

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Executing	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
    10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    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:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Temps de requête : 0.20 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.021 MB mémoire avant requête : 3.182 MB Rangées retournées : 1

    SELECT `alias`,`catid`
    
      FROM `qrsm4_content`
    
      WHERE `id` = 1382

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
    10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    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:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Temps de requête : 0.67 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.195 MB Rangées retournées : 50

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `qrsm4_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acychecker','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_ffexplorer','com_fields','com_finder','com_icagenda','com_installer','com_jaextmanager','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_myshortlist','com_newsfeeds','com_osmap','com_osmembership','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_regularlabsmanager','com_search','com_sitemapgenerator','com_tags','com_templates','com_users','com_webpushauto','com_wrapper')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qrsm4_assets	range	idx_asset_name	idx_asset_name	202	NULL	51	Using index condition

    Profil

    Status	Duration
    Starting	0.04 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.32 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:226
    8	plgSystemOSMembershipArticles->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Temps de requête : 0.45 ms Après la dernière requête : 2.73 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.362 MB

    UPDATE `qrsm4_extensions`
    
      SET `params` = '{\"mediaversion\":\"d0ca8dca395d989ce170cb307015e9c4\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init for update	0.04 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.22 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

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

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

    ---

19. Temps de requête : 2.05 ms Après la dernière requête : 2.34 ms Mémoire de requête : 0.157 MB mémoire avant requête : 3.472 MB Rangées retournées : 1409

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `qrsm4_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	qrsm4_assets	ALL	idx_asset_name,idx_parent_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3282	Using where

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    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:457
    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:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Temps de requête : 0.49 ms Après la dernière requête : 0.94 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.639 MB Rangées retournées : 31

    SHOW FULL COLUMNS 
      FROM `qrsm4_content`

    Explication

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

    Profil

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.00 ms
    Closing tables	0.00 ms
    Opening tables	0.14 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    Checking permissions	0.08 ms
    Closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Removing tmp table	0.05 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    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:328
    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:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Temps de requête : 0.31 ms Après la dernière requête : 1.24 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.682 MB

    UPDATE qrsm4_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '1382'

    Explication

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

    Profil

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init for update	0.02 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.13 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    10	Joomla\CMS\Table\Table->hit()	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:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Temps de requête : 0.38 ms Après la dernière requête : 1.11 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.785 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 qrsm4_content AS a
    
      INNER JOIN qrsm4_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN qrsm4_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN qrsm4_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN qrsm4_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 1382 
      AND c.published > 0 
      AND a.language in ('fr-FR','*') 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-07 15:39:58') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-07 15:39:58') 
      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,idx_language	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

    Status	Duration
    Starting	0.09 ms
    Checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    13	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Temps de requête : 0.47 ms Après la dernière requête : 1.21 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.864 MB Rangées retournées : 4

    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 `qrsm4_categories` AS `s`
    
      INNER JOIN `qrsm4_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('fr-FR','*')) 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 = 128
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	117	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.12 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Temps de requête : 2.56 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.898 MB Rangées retournées : 4

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `qrsm4_contentitem_tag_map` AS m 
    
      INNER JOIN `qrsm4_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1382 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5) 
      AND `language` IN ('fr-FR', '*')

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Temps de requête : 0.39 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.947 MB Rangées retournées : 8

    SELECT DISTINCT plan_id
    
      FROM qrsm4_osmembership_articles
    
      WHERE article_id = 1382

    Explication

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

    Profil

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Creating tmp table	0.01 ms
    Executing	0.00 ms
    Sending data	0.20 ms
    Removing tmp table	0.01 ms
    Sending data	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:488
    15	plgSystemOSMembershipArticles->getRequiredPlanIds()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:352
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Temps de requête : 0.19 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.955 MB Rangées retournées : 1

    SELECT catid
    
      FROM qrsm4_content
    
      WHERE id = 1382

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:501
    15	plgSystemOSMembershipArticles->getRequiredPlanIds()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:352
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Temps de requête : 0.29 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.964 MB Rangées retournées : 27

    SELECT id, params
    
      FROM qrsm4_osmembership_plans
    
      WHERE published = 1

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:508
    15	plgSystemOSMembershipArticles->getRequiredPlanIds()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:352
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Temps de requête : 0.26 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.999 MB Rangées retournées : 27

    SELECT id
    
      FROM qrsm4_osmembership_plans
    
      WHERE published = 0

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:531
    15	plgSystemOSMembershipArticles->getRequiredPlanIds()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:352
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Temps de requête : 0.28 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.059 MB mémoire avant requête : 4.981 MB Rangées retournées : 131

    SELECT `message_key`,`message`
    
      FROM qrsm4_osmembership_messages

    Explication

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.16 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmembership/libraries/mpf/config/config.php:42
    18	MPFConfig->__construct()	JROOT/components/com_osmembership/helper/helper.php:1668
    17	OSMembershipHelper::getMessages()	JROOT/components/com_osmembership/helper/helper.php:3864
    16	OSMembershipHelper::getContentRestrictedMessages()	JROOT/components/com_osmembership/helper/helper.php:148
    15	OSMembershipHelper::callOverridableHelperMethod()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:361
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Temps de requête : 0.25 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.048 MB Rangées retournées : 8

    SELECT `title` AS `title`
    
      FROM qrsm4_osmembership_plans
    
      WHERE id IN (59,17,3,18,22,2,41,61) 
      AND published = 1
    
      ORDER BY ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qrsm4_osmembership_plans	range	PRIMARY	PRIMARY	4	NULL	8	Using index condition; Using where; Utilisation du tri complet de type filesort

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    18	JDatabaseDriver->loadColumn()	JROOT/components/com_osmembership/helper/helper.php:3900
    17	OSMembershipHelper::getPlanTitles()	JROOT/components/com_osmembership/helper/helper.php:3876
    16	OSMembershipHelper::getContentRestrictedMessages()	JROOT/components/com_osmembership/helper/helper.php:148
    15	OSMembershipHelper::callOverridableHelperMethod()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:361
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

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

    SELECT category_id
    
      FROM qrsm4_osmembership_plans
    
      WHERE id = 59

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_osmembership/helper/helper.php:3779
    18	OSMembershipHelper::getRestrictionRedirectUrl()	JROOT/components/com_osmembership/helper/helper.php:148
    17	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/helper/helper.php:3837
    16	OSMembershipHelper::getPluginRestrictionRedirectUrl()	JROOT/components/com_osmembership/helper/helper.php:148
    15	OSMembershipHelper::callOverridableHelperMethod()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:366
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Temps de requête : 0.23 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.067 MB Rangées retournées : 7

    SELECT id
    
      FROM qrsm4_osmembership_plans
    
      WHERE category_id = 2 
      AND published = 1

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    19	JDatabaseDriver->loadColumn()	JROOT/components/com_osmembership/helper/helper.php:3802
    18	OSMembershipHelper::getRestrictionRedirectUrl()	JROOT/components/com_osmembership/helper/helper.php:148
    17	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/helper/helper.php:3837
    16	OSMembershipHelper::getPluginRestrictionRedirectUrl()	JROOT/components/com_osmembership/helper/helper.php:148
    15	OSMembershipHelper::callOverridableHelperMethod()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:366
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Temps de requête : 0.20 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.085 MB Rangées retournées : 8

    SELECT title
    
      FROM qrsm4_osmembership_plans
    
      WHERE id IN (59,17,3,18,22,2,41,61) 
      AND published = 1
    
      ORDER BY ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qrsm4_osmembership_plans	range	PRIMARY	PRIMARY	4	NULL	8	Using index condition; Using where; Utilisation du tri complet de type filesort

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:552
    15	plgSystemOSMembershipArticles->getPlanTitles()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:379
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Temps de requête : 0.20 ms Après la dernière requête : 4.46 ms Mémoire de requête : 0.036 MB mémoire avant requête : 5.709 MB Rangées retournées : 1

    SELECT `params`
     
      FROM `qrsm4_comprofiler_plugin`
     
      WHERE `id` = 1

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    43	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
    42	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
    41	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:47
    40	CB\Application\CBApplication::CB\Application\{closure}()	Same as call in the line below.
    39	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
    38	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:78
    37	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:607
    36	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
    35	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:212
    34	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
    33	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:102
    32	CB\Legacy\LegacyFoundationFunctions->__construct()	Same as call in the line below.
    31	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:645
    30	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
    29	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:134
    28	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:34
    27	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/modules/mod_cblogin/mod_cblogin.php:22
    26	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    25	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    24	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    23	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:215
    22	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:120
    21	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:380
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Temps de requête : 0.29 ms Après la dernière requête : 1.33 ms Mémoire de requête : 0.029 MB mémoire avant requête : 5.760 MB Rangées retournées : 7

    SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
     
      FROM `qrsm4_comprofiler_plugin`
     
      WHERE `published` = 1
     
      AND `viewaccesslevel` IN (1,5)
     
      AND `type` = 'user'
     
      ORDER BY `ordering`

    Explication

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

    Profil

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

    Pile d'appels

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    30	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
    29	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
    28	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
    27	cbPluginHandler->loadPluginGroup()	JROOT/modules/mod_cblogin/mod_cblogin.php:64
    26	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    25	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    24	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    23	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:215
    22	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:120
    21	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:380
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Temps de requête : 0.72 ms Après la dernière requête : 6.02 ms Mémoire de requête : 0.044 MB mémoire avant requête : 5.888 MB Rangées retournées : 312
    Requêtes dupliquées: #10

    SHOW TABLES

    Explication

    EXPLAIN impossible sur la requête : SHOW TABLES

    Profil

    Status	Duration
    Starting	0.01 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.00 ms
    Checking permissions	0.48 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Removing tmp table	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Pile d'appels

    #	Caller	File and line number
    43	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    42	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
    41	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:724
    40	acymailing_getTableList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:18
    39	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:537
    38	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:1080
    37	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:24
    36	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/components/com_comprofiler/plugin/user/plug_acymailingcbplugin/acymailing.php:8
    35	require_once JROOT/components/com_comprofiler/plugin/user/plug_acymailingcbplugin/acymailing.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    34	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    33	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:21
    32	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    31	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    30	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php:22
    29	require_once JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    28	cbPluginHandler->_loadPluginFile()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    27	cbPluginHandler->loadPluginGroup()	JROOT/modules/mod_cblogin/mod_cblogin.php:64
    26	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    25	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    24	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    23	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:215
    22	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:120
    21	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/osmembershiparticles/osmembershiparticles.php:380
    14	plgSystemOSMembershipArticles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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/Compone