{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1544711547,
                "last": 1544711547,
                "now": 1544711547
            }
        },
        "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"
        },
        "com_mailto": {
            "links": {
                "3aa396b460b2deccd74397eadf4ebb1905a415f7": {
                    "link": "http:\/\/irvt.agrinet.tn\/index.php\/fr\/sample-data\/item\/116-visite-delegation-russe",
                    "expiry": 1544711547
                }
            }
        }
    }
}

Temps

Mémoire

40 requêtes exécutées 35.41 ms

1. Temps de requête : 9.75 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.577 MB

   DELETE 
   
     FROM `instm_session`
   
     WHERE `time` < '1544707947'

   Explication

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	DELETE	instm_session	NULL	range	time	time	59	const	1	100.00	Using where

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   init	0.01 ms
   System lock	0.05 ms
   updating	6.03 ms
   end	0.01 ms
   query end	3.45 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
   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:413
   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 : 0.16 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.610 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `instm_session`
   
     WHERE `session_id` = '1hhfgdqpmikqsgn6hfaocrub40'

   Explication

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	instm_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
   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:413
   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.14 ms Après la dernière requête : 1.17 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.778 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `instm_session`
   
     WHERE `session_id` = '1hhfgdqpmikqsgn6hfaocrub40' 
     LIMIT 1

   Explication

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	instm_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   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:413
   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 : 3.71 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.793 MB

   INSERT INTO `instm_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('1hhfgdqpmikqsgn6hfaocrub40', 1, '1544711547', 0, '', 0)

   Explication

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.04 ms
   end	0.00 ms
   query end	3.56 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   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:413
   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.40 ms Après la dernière requête : 2.14 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.088 MB Rangées retournées : 36

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

   Explication

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	instm_extensions	NULL	ref	extension	extension	82	const	36	100.00	NULL

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
   9	JComponentHelper::{closure}()	Même appel que celui de la ligne ci-dessous.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.19 ms Après la dernière requête : 2.12 ms Mémoire de requête : 0.014 MB mémoire avant requête : 4.434 MB Rangées retournées : 5

   SELECT id, rules
   
     FROM `instm_viewlevels`

   Explication

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

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.35 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.015 MB mémoire avant requête : 4.459 MB Rangées retournées : 1

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

   Explication

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

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.53 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.017 MB mémoire avant requête : 4.565 MB Rangées retournées : 75

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

   Explication

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	instm_extensions	NULL	ref	extension	extension	82	const	75	0.40	Using index condition; Using where; Utilisation du tri complet de type filesort

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.30 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
   9	JPluginHelper::{closure}()	Même appel que celui de la ligne ci-dessous.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.28 ms Après la dernière requête : 12.90 ms Mémoire de requête : 0.020 MB mémoire avant requête : 6.543 MB Rangées retournées : 3

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

   Explication

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

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.06 ms
   init	0.03 ms
   System lock	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.01 ms
   Creating sort index	0.05 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
   10	JLanguageHelper::getLanguages()	JROOT/plugins/system/admintools/admintools/main.php:497
   9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:447
   8	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:90
   7	plgSystemAdmintools->__construct()	JROOT/libraries/cms/plugin/helper.php:271
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.20 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.016 MB mémoire avant requête : 6.568 MB Rangées retournées : 0

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

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:526
    9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:447
    8	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:90
    7	plgSystemAdmintools->__construct()	JROOT/libraries/cms/plugin/helper.php:271
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.17 ms Après la dernière requête : 0.69 ms Mémoire de requête : 0.017 MB mémoire avant requête : 6.673 MB Rangées retournées : 0

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

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/models/storage.php:99
    11	AdmintoolsModelStorage->load()	JROOT/administrator/components/com_admintools/models/storage.php:49
    10	AdmintoolsModelStorage->getValue()	JROOT/plugins/system/admintools/feature/linkmigration.php:32
    9	AtsystemFeatureLinkmigration->isEnabled()	JROOT/plugins/system/admintools/admintools/main.php:356
    8	plgSystemAdmintools->loadFeatures()	JROOT/plugins/system/admintools/admintools/main.php:93
    7	plgSystemAdmintools->__construct()	JROOT/libraries/cms/plugin/helper.php:271
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.22 ms Après la dernière requête : 7.01 ms Mémoire de requête : 0.015 MB mémoire avant requête : 7.684 MB Rangées retournées : 6

    SELECT `element`,`name`,`client_id`,`extension_id`
    
      FROM `instm_extensions`
    
      WHERE `type` = 'language' 
      AND `state` = 0 
      AND `enabled` = 1

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_extensions	NULL	ref	extension	extension	82	const	6	1.00	Using where

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
    8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
    7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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 : 0.40 ms Après la dernière requête : 5.21 ms Mémoire de requête : 0.018 MB mémoire avant requête : 8.344 MB Rangées retournées : 1

    SHOW VARIABLES LIKE "collation_database"

    Explication

    EXPLAIN impossible sur la requête : SHOW VARIABLES LIKE "collation_database"

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:337
    12	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
    11	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:685
    10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:118
    9	plgSystemAdmintools->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.24 ms Après la dernière requête : 2.58 ms Mémoire de requête : 0.027 MB mémoire avant requête : 8.827 MB Rangées retournées : 1

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

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    21	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
    20	JLibraryHelper::{closure}()	Même appel que celui de la ligne ci-dessous.
    19	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
    18	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
    17	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
    16	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
    15	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
    14	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    13	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    12	JFactory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
    11	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
    10	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
    9	plgSystemHelix->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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 : 3.94 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.020 MB mémoire avant requête : 8.837 MB

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

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	instm_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.09 ms
    updating	0.07 ms
    end	0.01 ms
    query end	3.66 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    16	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    15	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    14	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    13	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    12	JFactory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
    11	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
    10	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
    9	plgSystemHelix->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.98 ms Après la dernière requête : 2.45 ms Mémoire de requête : 0.040 MB mémoire avant requête : 9.234 MB Rangées retournées : 37

    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 instm_menu AS m
    
      LEFT JOIN instm_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	149	3.33	Using index condition; Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	irvt2017.m.component_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.61 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
    24	JMenuSite->{closure}()	Même appel que celui de la ligne ci-dessous.
    23	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
    22	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
    21	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    20	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    19	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
    18	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
    17	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    16	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:433
    15	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
    14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
    13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
    12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
    11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
    10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
    9	plgSystemHelix->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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 : 1.93 ms Après la dernière requête : 1.22 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.482 MB Rangées retournées : 3

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

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_template	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	20.00	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	irvt2017.s.template,const	1	4.53	Using index condition; Using where

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
    15	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
    14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
    13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
    12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
    11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
    10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
    9	plgSystemHelix->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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 : 0.77 ms Après la dernière requête : 30.19 ms Mémoire de requête : 0.020 MB mémoire avant requête : 12.255 MB Rangées retournées : 36

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `instm_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_admintools','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_spidercontacts','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_assets	NULL	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	221	16.74	Using where

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    11	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    10	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    9	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    8	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.32 ms Après la dernière requête : 10.12 ms Mémoire de requête : 0.019 MB mémoire avant requête : 14.235 MB Rangées retournées : 2

    SELECT id 
      FROM instm_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1)

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_k2_categories	NULL	ref	category,published,access,trash	trash	2	const	2	64.00	Using where

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:274
    12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:36
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.34 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.027 MB mémoire avant requête : 14.254 MB Rangées retournées : 1

    SELECT * 
      FROM instm_k2_items 
      WHERE id=116 
      AND language IN ('fr-FR','*') 
      LIMIT 0, 1

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_k2_items	NULL	const	PRIMARY,language	PRIMARY	4	const	1	100.00	NULL

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:36
    12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:42
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.49 ms Après la dernière requête : 0.67 ms Mémoire de requête : 0.027 MB mémoire avant requête : 14.389 MB Rangées retournées : 14

    SHOW FULL COLUMNS 
      FROM `instm_k2_categories`

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.14 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    15	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:36
    14	TableK2Category->__construct()	JROOT/libraries/joomla/table/table.php:311
    13	JTable::getInstance()	JROOT/components/com_k2/models/item.php:74
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.17 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.463 MB Rangées retournées : 1

    SELECT * 
      FROM instm_k2_categories 
      WHERE id = '4'

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_k2_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
    13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:75
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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 : 2.16 ms Mémoire de requête : 0.020 MB mémoire avant requête : 14.698 MB Rangées retournées : 0

    SELECT tag.*
    		
      FROM instm_k2_tags AS tag
    		JOIN instm_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
    		
      WHERE tag.published=1
    		
      AND xref.itemID = 116 
      ORDER BY xref.id ASC

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	xref	NULL	ref	tagID,itemID	itemID	4	const	1	100.00	Using index condition; Utilisation du tri complet de type filesort
    1	SIMPLE	tag	NULL	eq_ref	PRIMARY,published	PRIMARY	4	irvt2017.xref.tagID	1	80.00	Using where

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.15 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1403
    13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:109
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.23 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.021 MB mémoire avant requête : 14.720 MB Rangées retournées : 0

    SELECT * 
      FROM instm_k2_attachments 
      WHERE itemID=116

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1693
    13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:190
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.20 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.740 MB Rangées retournées : 0

    SELECT * 
      FROM instm_k2_rating 
      WHERE itemID = 116

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1018
    14	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:1074
    13	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:196
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.44 ms Après la dernière requête : 1.12 ms Mémoire de requête : 0.033 MB mémoire avant requête : 14.954 MB Rangées retournées : 16

    SHOW FULL COLUMNS 
      FROM `instm_users`

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.02 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    20	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
    19	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
    18	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:598
    17	JUser::getTable()	JROOT/libraries/joomla/user/user.php:875
    16	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    15	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    14	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    13	JFactory::getUser()	JROOT/components/com_k2/models/item.php:248
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.17 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.028 MB mémoire avant requête : 15.021 MB Rangées retournées : 1

    SELECT *
    
      FROM `instm_users`
    
      WHERE `id` = 1129

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
    17	JTableUser->load()	JROOT/libraries/joomla/user/user.php:878
    16	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    15	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    14	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    13	JFactory::getUser()	JROOT/components/com_k2/models/item.php:248
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.42 ms Après la dernière requête : 3.20 ms Mémoire de requête : 0.025 MB mémoire avant requête : 15.970 MB Rangées retournées : 5

    SELECT `g`.`id`,`g`.`title`
    
      FROM `instm_usergroups` AS g
    
      INNER JOIN `instm_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 1129

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	5	100.00	Using index
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	irvt2017.m.group_id	1	100.00	NULL

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    18	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
    17	JTableUser->load()	JROOT/libraries/joomla/user/user.php:878
    16	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    15	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    14	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    13	JFactory::getUser()	JROOT/components/com_k2/models/item.php:248
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.22 ms Après la dernière requête : 1.40 ms Mémoire de requête : 0.021 MB mémoire avant requête : 15.991 MB Rangées retournées : 0
    Requêtes dupliquées: #30

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM instm_k2_users 
      WHERE userID=1129

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_k2_users	NULL	ref	userID	userID	4	const	1	100.00	NULL

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1874
    13	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:251
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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 : 0.14 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.022 MB mémoire avant requête : 16.012 MB Rangées retournées : 0
    Requêtes dupliquées: #29

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM instm_k2_users 
      WHERE userID=1129

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_k2_users	NULL	ref	userID	userID	4	const	1	100.00	NULL

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1874
    14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:55
    13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:252
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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 : 0.50 ms Après la dernière requête : 7.86 ms Mémoire de requête : 0.029 MB mémoire avant requête : 17.059 MB Rangées retournées : 36

    SHOW FULL COLUMNS 
      FROM `instm_k2_items`

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    15	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:58
    14	TableK2Item->__construct()	JROOT/libraries/joomla/table/table.php:311
    13	JTable::getInstance()	JROOT/components/com_k2/models/item.php:923
    12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:136
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.19 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.017 MB mémoire avant requête : 17.154 MB

    UPDATE instm_k2_items
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '116'

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	instm_k2_items	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.02 ms
    updating	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
    13	JTable->hit()	JROOT/components/com_k2/models/item.php:924
    12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:136
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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 : 0.29 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.021 MB mémoire avant requête : 17.171 MB Rangées retournées : 0

    SELECT * 
      FROM instm_k2_comments 
      WHERE itemID=116 
      AND published=1  
      ORDER BY commentDate DESC

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_k2_comments	NULL	ref	itemID,published,latestComments,countComments	itemID	4	const	1	99.74	Using index condition; Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.09 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1717
    12	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:242
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->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.36 ms Après la dernière requête : 0.97 ms Mémoire de requête : 0.027 MB mémoire avant requête : 17.333 MB Rangées retournées : 1

    SELECT * 
      FROM instm_k2_items 
      WHERE id != 116 
      AND catid=4 
      AND ordering > 45 
      AND published=1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-12-13 14:32:27' ) 
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-12-13 14:32:27' )  
      AND access IN(1,1) 
      AND trash=0 
      AND language IN ('fr-FR','*') 
      ORDER BY ordering ASC 
      LIMIT 0, 1

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_k2_items	NULL	range	PRIMARY,item,catid,ordering,language	ordering	4	NULL	71	0.20	Using index condition; Using where

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1855
    12	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:323
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->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.32 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.027 MB mémoire avant requête : 17.363 MB Rangées retournées : 1

    SELECT * 
      FROM instm_k2_items 
      WHERE id != 116 
      AND catid=4 
      AND ordering < 45 
      AND published=1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-12-13 14:32:27' ) 
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-12-13 14:32:27' )  
      AND access IN(1,1) 
      AND trash=0 
      AND language IN ('fr-FR','*') 
      ORDER BY ordering DESC 
      LIMIT 0, 1

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_k2_items	NULL	range	PRIMARY,item,catid,ordering,language	ordering	4	NULL	38	0.20	Using index condition; Using where

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1810
    12	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:364
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->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.37 ms Après la dernière requête : 4.08 ms Mémoire de requête : 0.015 MB mémoire avant requête : 17.484 MB Rangées retournées : 4

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

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	instm_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	150	1.00	Using where

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
    9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:718
    8	PlgSystemLanguageFilter->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Temps de requête : 1.27 ms Après la dernière requête : 21.80 ms Mémoire de requête : 0.025 MB mémoire avant requête : 19.093 MB Rangées retournées : 20

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM instm_modules AS m
    
      LEFT JOIN instm_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN instm_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 <= '2018-12-13 14:32:27') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-12-13 14:32:27') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 211 OR mm.menuid <= 0) 
      AND m.language IN ('fr-FR','*')
    
      ORDER BY m.position, m.ordering

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	38	0.32	Using index condition; Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	irvt2017.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	irvt2017.m.id	4	40.00	Using where; Using index

    Profil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.65 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:413
    15	JModuleHelper::getModuleList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:356
    14	JModuleHelper::load()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:84
    13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    12	JDocumentHtml->countModules()	JROOT/plugins/system/helix/core/helix.php:735
    11	Helix::countModules()	JROOT/plugins/system/helix/core/helix.php:351
    10	Helix::showRow()	JROOT/plugins/system/helix/core/helix.php:448
    9	Helix::generatelayout()	JROOT/plugins/system/helix/core/helix.php:713
    8	Helix::layout()	JROOT/templates/vina_bakery_ii/index.php:50
    7	require JROOT/templates/vina_bakery_ii/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Temps de requête : 0.21 ms Après la dernière requête : 15.13 ms Mémoire de requête : 0.019 MB mémoire avant requête : 19.424 MB Rangées retournées : 27

    SELECT guest, client_id
    
      FROM instm_session
    
      WHERE client_id = 0

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:45
    11	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
    10	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

39. Temps de requête : 0.53 ms Après la dernière requête : 4.16 ms Mémoire de requête : 0.022 MB mémoire avant requête : 19.928 MB Rangées retournées : 0

    SELECT DAY(created) AS day, COUNT(*) AS counter 
      FROM instm_k2_items 
      WHERE YEAR(created)=2018 
      AND MONTH(created)=12 
      AND published=1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-12-13 14:32:27' ) 
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-12-13 14:32:27' ) 
      AND trash=0 
      AND  access IN(1,1)   
      AND language IN ('fr-FR', '*')  
      AND EXISTS(SELECT * 
      FROM instm_k2_categories 
      WHERE id= instm_k2_items.catid 
      AND published=1 
      AND trash=0 
      AND  access IN(1,1)   
      AND language IN ('fr-FR', '*') ) 
      GROUP BY day

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	instm_k2_items	NULL	range	item,created,language	item	7	NULL	35	0.79	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    2	DEPENDENT SUBQUERY	instm_k2_categories	NULL	eq_ref	PRIMARY,category,published,access,trash,language	PRIMARY	4	irvt2017.instm_k2_items.catid	1	32.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_tools/helper.php:1160
    15	MyCalendar->getDateLink()	JROOT/modules/mod_k2_tools/includes/calendarClass.php:296
    14	Calendar->getMonthHTML()	JROOT/modules/mod_k2_tools/includes/calendarClass.php:167
    13	Calendar->getMonthView()	JROOT/modules/mod_k2_tools/includes/calendarClass.php:148
    12	Calendar->getCurrentMonthView()	JROOT/modules/mod_k2_tools/helper.php:1048
    11	modK2ToolsHelper::calendar()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:67
    10	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

40. Temps de requête : 3.50 ms Après la dernière requête : 2.63 ms Mémoire de requête : 0.027 MB mémoire avant requête : 20.146 MB Rangées retournées : 3

    SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
      FROM instm_k2_items as i RIGHT JOIN instm_k2_categories c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1)  
      AND c.trash = 0 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-12-13 14:32:27' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-12-13 14:32:27' ) 
      AND c.language IN ('fr-FR', '*') 
      AND i.language IN ('fr-FR', '*') 
      ORDER BY i.id DESC 
      LIMIT 0, 3

    Explication

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	PRIMARY,category,published,access,trash,language	trash	2	const	2	51.20	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	i	NULL	ref	item,catid,language	catid	4	irvt2017.c.id	22	0.26	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    Creating tmp table	0.05 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	2.75 ms
    Creating sort index	0.11 ms
    end	0.00 ms
    query end	0.00 ms
    removing tmp table	0.04 ms
    query end	0.00 ms
    closing tables	0.17 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:286
    11	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
    10	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---