Console de débogage Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675608131,
                "last": 1675608131,
                "now": 1675608131
            },
            "token": "pxxa7qqqr4b6rv8qW7AZBevT8Hps7vYO"
        },
        "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
        }
    }
}

Temps

Mémoire

33 requêtes exécutées 25.92 ms

1. Temps de requête : 0.55 ms Mémoire de requête : 0.018 MB mémoire avant requête : 0.907 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `ef32s_session`
   
     WHERE `session_id` = 'rvbgem8hi2c2ktrkuaukaea4l6'

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ef32s_session	const	PRIMARY	PRIMARY	766	const	1

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Checking query cache for query	0.04 ms
   Checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.01 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.01 ms

   #	Appel	Fichier et numéro de ligne
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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 : 2.99 ms Après la dernière requête : 1.51 ms Mémoire de requête : 0.008 MB mémoire avant requête : 0.970 MB

   DELETE 
   
     FROM `ef32s_session`
   
     WHERE `time` < '1675586531'

   EXPLAIN impossible sur la requête : DELETE FROM `ef32s_session` WHERE `time` < '1675586531'

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

   #	Appel	Fichier et numéro de ligne
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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.69 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.012 MB mémoire avant requête : 0.982 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `ef32s_session`
   
     WHERE `session_id` = 'rvbgem8hi2c2ktrkuaukaea4l6' 
     LIMIT 1

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

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Checking query cache for query	0.06 ms
   Checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   Waiting for query cache lock	0.03 ms
   Init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.06 ms
   Preparing	0.02 ms
   Executing	0.04 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.03 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.01 ms
   Storing result in query cache	0.02 ms
   Reset for next command	0.01 ms

   #	Appel	Fichier et numéro de ligne
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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 : 2.62 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.009 MB mémoire avant requête : 0.997 MB

   INSERT INTO `ef32s_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('rvbgem8hi2c2ktrkuaukaea4l6', 0, 1, '1675608131', 0, '')

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

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

   #	Appel	Fichier et numéro de ligne
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

5. Temps de requête : 0.28 ms Après la dernière requête : 1.01 ms Mémoire de requête : 0.018 MB mémoire avant requête : 1.052 MB Rangées retournées : 38

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `ef32s_extensions`
   
     WHERE `type` = 'component'

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ef32s_extensions	ref	extension	extension	82	const	38	Using index condition

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Checking query cache for query	0.02 ms
   Checking privileges on cached	0.01 ms
   Checking permissions	0.02 ms
   Sending cached result to clien	0.04 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.23 ms Après la dernière requête : 0.78 ms Mémoire de requête : 0.015 MB mémoire avant requête : 1.120 MB Rangées retournées : 2

   SELECT b.id
   
     FROM ef32s_usergroups AS a
   
     LEFT JOIN ef32s_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

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

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Checking query cache for query	0.02 ms
   Checking privileges on cached	0.01 ms
   Checking permissions	0.02 ms
   Sending cached result to clien	0.03 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.23 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.014 MB mémoire avant requête : 1.140 MB Rangées retournées : 5

   SELECT id, rules
   
     FROM `ef32s_viewlevels`

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

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.01 ms
   Checking permissions	0.02 ms
   Sending cached result to clien	0.03 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.19 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.014 MB mémoire avant requête : 1.159 MB Rangées retournées : 71

   SELECT folder AS type, element AS name, params
   
     FROM ef32s_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

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

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.01 ms
   Checking permissions	0.01 ms
   Sending cached result to clien	0.03 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   #	Appel	Fichier et numéro de ligne
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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 : 0.83 ms Mémoire de requête : 0.014 MB mémoire avant requête : 1.237 MB Rangées retournées : 3

   SELECT *
   
     FROM ef32s_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

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

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.01 ms
   Checking permissions	0.02 ms
   Sending cached result to clien	0.03 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   #	Appel	Fichier et numéro de ligne
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
   5	JLanguageHelper::getLanguages()	JROOT/libraries/joomla/language/helper.php:85
   4	JLanguageHelper::detectLanguage()	JROOT/libraries/cms/application/site.php:648
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.22 ms Après la dernière requête : 4.98 ms Mémoire de requête : 0.017 MB mémoire avant requête : 1.571 MB Rangées retournées : 0

    SELECT `path`
    
      FROM ef32s_rsfirewall_ignored
    
      WHERE `type`='ignore_folder' OR `type`='ignore_file'

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

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.02 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
    10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
    9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
    8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
    7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.14 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.017 MB mémoire avant requête : 1.587 MB Rangées retournées : 0

    SELECT `file`
    
      FROM ef32s_rsfirewall_hashes
    
      WHERE `type`='protect'

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

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
    10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
    9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
    8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
    7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.14 ms Mémoire de requête : 0.019 MB mémoire avant requête : 1.601 MB Rangées retournées : 52

    SELECT *
    
      FROM ef32s_rsfirewall_configuration

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

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
    10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
    9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
    8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
    7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Temps de requête : 1.78 ms Après la dernière requête : 4.33 ms Mémoire de requête : 0.024 MB mémoire avant requête : 1.909 MB Rangées retournées : 10

    SHOW FULL COLUMNS 
      FROM `ef32s_rsfirewall_logs`

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

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

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
    11	RsfirewallTableLogs->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
    9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
    8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:50
    7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.30 ms Après la dernière requête : 13.13 ms Mémoire de requête : 0.019 MB mémoire avant requête : 2.383 MB Rangées retournées : 1
    Requêtes dupliquées: #15

    SELECT template
    
      FROM ef32s_template_styles as s
    
      WHERE s.client_id = 0 
      AND s.home = 1

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

    Status	Duration
    Starting	0.04 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.02 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
    11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
    10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
    9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:99
    8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:57
    7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.14 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.020 MB mémoire avant requête : 2.402 MB Rangées retournées : 1
    Requêtes dupliquées: #14

    SELECT template
    
      FROM ef32s_template_styles as s
    
      WHERE s.client_id = 0 
      AND s.home = 1

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

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
    12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
    11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
    10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
    9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:99
    8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:57
    7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.22 ms Après la dernière requête : 3.78 ms Mémoire de requête : 0.015 MB mémoire avant requête : 2.609 MB Rangées retournées : 2

    SELECT extension, file, type
    
      FROM ef32s_rokcommon_configs
    
      ORDER BY priority

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

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:130
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:78
    7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.22 ms Après la dernière requête : 2.57 ms Mémoire de requête : 0.014 MB mémoire avant requête : 2.705 MB Rangées retournées : 3

    SELECT element
    
      FROM ef32s_extensions
    
      WHERE type = 'language' 
      AND client_id = 0 
      AND enabled = 1

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

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
    8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
    7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.85 ms Après la dernière requête : 2.15 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.849 MB Rangées retournées : 17

    SHOW FULL COLUMNS 
      FROM `ef32s_extensions`

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

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

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
    11	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:46
    9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 0.22 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.016 MB mémoire avant requête : 2.908 MB Rangées retournées : 1

    SELECT `extension_id`
    
      FROM `ef32s_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

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

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:50
    9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.14 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.020 MB mémoire avant requête : 2.926 MB Rangées retournées : 1
    Requêtes dupliquées: #22

    SELECT *
    
      FROM ef32s_extensions
    
      WHERE `extension_id` = '10027'

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

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:55
    9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.13 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.016 MB mémoire avant requête : 2.940 MB Rangées retournées : 1

    SELECT `extension_id`
    
      FROM `ef32s_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

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

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:73
    9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.14 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.020 MB mémoire avant requête : 2.956 MB Rangées retournées : 1
    Requêtes dupliquées: #20

    SELECT *
    
      FROM ef32s_extensions
    
      WHERE `extension_id` = '10027'

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

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:77
    9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.37 ms Après la dernière requête : 71.94 ms Mémoire de requête : 0.042 MB mémoire avant requête : 3.207 MB Rangées retournées : 57

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM ef32s_menu AS m
    
      LEFT JOIN ef32s_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

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

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.02 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.06 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
    16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
    15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
    13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
    12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
    11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
    9	PlgSystemLanguageFilter->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Temps de requête : 0.22 ms Après la dernière requête : 12.92 ms Mémoire de requête : 0.016 MB mémoire avant requête : 4.198 MB Rangées retournées : 4

    SELECT *
    
      FROM ef32s_rsfirewall_hashes
    
      WHERE (`type`='3.6.5' OR `type`='protect') 
      AND `flag`!='C'

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

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.02 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:993
    9	plgSystemRSFirewall->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.21 ms Après la dernière requête : 0.76 ms Mémoire de requête : 0.017 MB mémoire avant requête : 4.224 MB Rangées retournées : 0

    SELECT *
    
      FROM ef32s_rsfirewall_snapshots
    
      WHERE `type`='protect'

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

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
    10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1016
    9	plgSystemRSFirewall->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.13 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.017 MB mémoire avant requête : 4.240 MB Rangées retournées : 0

    SELECT `ip`,`reason`
    
      FROM ef32s_rsfirewall_lists
    
      WHERE (`ip`='3.236.47.240' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='1' 
      AND `published`='1'

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ef32s_rsfirewall_lists	ref	published,type,ip	published	1	const	1	Using where

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
    11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:148
    10	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1052
    9	plgSystemRSFirewall->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.13 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.017 MB mémoire avant requête : 4.256 MB Rangées retournées : 0

    SELECT `ip`,`reason`
    
      FROM ef32s_rsfirewall_lists
    
      WHERE (`ip`='3.236.47.240' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='0' 
      AND `published`='1'

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ef32s_rsfirewall_lists	ref	published,type,ip	published	1	const	1	Using where

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
    11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:138
    10	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1056
    9	plgSystemRSFirewall->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.22 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.018 MB mémoire avant requête : 4.276 MB Rangées retournées : 0

    SELECT *
    
      FROM ef32s_rsfirewall_exceptions
    
      WHERE `published`='1'

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

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.02 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:661
    10	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1109
    9	plgSystemRSFirewall->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.97 ms Après la dernière requête : 0.51 ms Mémoire de requête : 0.019 MB mémoire avant requête : 4.305 MB Rangées retournées : 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `ef32s_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

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

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.09 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    Init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.15 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.12 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	Même appel que celui de la ligne ci-dessous.
    12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 3.05 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.306 MB

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

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

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

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.13 ms Après la dernière requête : 1.03 ms Mémoire de requête : 0.010 MB mémoire avant requête : 4.389 MB Rangées retournées : 6

    SELECT id, home, template, s.params
    
      FROM ef32s_template_styles as s
    
      LEFT JOIN ef32s_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
    1	SIMPLE	s	ALL	idx_template	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	Using where; Using join buffer (flat, BNL join)

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.11 ms
    Checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    Init	0.06 ms
    Optimizing	0.06 ms
    Statistics	0.13 ms
    Preparing	0.09 ms
    Executing	0.01 ms
    Sending data	0.20 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.22 ms Après la dernière requête : 13.68 ms Mémoire de requête : 0.015 MB mémoire avant requête : 4.817 MB Rangées retournées : 4

    SELECT language,id
    
      FROM `ef32s_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ef32s_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	141	Using where

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.02 ms
    Checking privileges on cached	0.01 ms
    Checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
    9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
    8	PlgSystemLanguageFilter->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 5.57 ms Après la dernière requête : 2.77 ms Mémoire de requête : 0.056 MB mémoire avant requête : 4.898 MB Rangées retournées : 49

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ef32s_modules AS m
    
      LEFT JOIN ef32s_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ef32s_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-02-05 14:42:11') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-05 14:42:11') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 0 OR mm.menuid <= 0) 
      AND m.language IN ('fr-FR','*')
    
      ORDER BY m.position, m.ordering

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	136	Using index condition; Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	Kommand_joomla.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Kommand_joomla.m.id	1	Using where; Using index

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Checking query cache for query	0.21 ms
    Checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    Init	0.11 ms
    Optimizing	0.10 ms
    Statistics	0.21 ms
    Preparing	0.12 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	1.94 ms
    Waiting for query cache lock	0.02 ms
    Creating sort index	1.28 ms
    Waiting for query cache lock	0.01 ms
    Creating sort index	0.34 ms
    Waiting for query cache lock	0.01 ms
    Creating sort index	0.13 ms
    Waiting for query cache lock	0.01 ms
    Creating sort index	0.03 ms
    Waiting for query cache lock	0.01 ms
    Creating sort index	0.47 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    8	JDocumentHtml->countModules()	JROOT/templates/avendor/index.php:104
    7	require JROOT/templates/avendor/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

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

Tables sélectionnées :

1. 2 × SELECT `ip`,`reason` 
     FROM ef32s_rsfirewall_lists

2. 2 × SELECT `extension_id` 
     FROM `ef32s_extensions`

3. 2 × SELECT template 
     FROM ef32s_template_styles as s

4. 2 × SELECT * 
     FROM ef32s_extensions

5. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `ef32s_extensions`

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

7. 1 × SELECT * 
     FROM ef32s_rsfirewall_hashes

8. 1 × SELECT * 
     FROM ef32s_rsfirewall_exceptions

9. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM ef32s_modules AS m 
     LEFT JOIN ef32s_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN ef32s_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

10. 1 × SELECT language,id 
      FROM `ef32s_menu`

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

12. 1 × SELECT * 
      FROM ef32s_rsfirewall_snapshots

13. 1 × SELECT extension, file, type 
      FROM ef32s_rokcommon_configs

14. 1 × SELECT folder AS type, element AS name, params 
      FROM ef32s_extensions

15. 1 × SELECT id, rules 
      FROM `ef32s_viewlevels

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

17. 1 × SELECT `session_id` 
      FROM `ef32s_session`

18. 1 × SELECT * 
      FROM ef32s_languages

19. 1 × SELECT `path` 
      FROM ef32s_rsfirewall_ignored

20. 1 × SELECT `data` 
      FROM `ef32s_session`

21. 1 × SELECT * 
      FROM ef32s_rsfirewall_configuratio

22. 1 × SELECT `file` 
      FROM ef32s_rsfirewall_hashes

23. 1 × SELECT element 
      FROM ef32s_extensions

Autres tables :

1. 1 × UPDATE `ef32s_extensions` 
     SET `params` = '{\"mediaversion\":\"cb8ce9863ceb2d62d766c2705f02baf4\"}'

2. 1 × SHOW FULL COLUMNS 
     FROM `ef32s_extensions

3. 1 × SHOW FULL COLUMNS 
     FROM `ef32s_rsfirewall_logs

4. 1 × INSERT INTO `ef32s_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES  ('rvbgem8hi2c2ktrkuaukaea4l6', 0, 1, '1675608131', 0, ''

5. 1 × DELETE  
     FROM `ef32s_session`