Console de débogage Joomla!

Session

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

Profil d'information

Temps

Mémoire

Temps: 7.23 ms / 7.23 ms Mémoire: 0.874 MB / 1.09 MB Application: afterLoad

Temps: 78.38 ms / 85.60 ms Mémoire: 9.551 MB / 10.64 MB Application: afterInitialise

Temps: 12.95 ms / 98.55 ms Mémoire: 1.501 MB / 12.14 MB Application: afterRoute

Temps: 0.81 ms / 99.36 ms Mémoire: 0.051 MB / 12.19 MB Application: beforeRenderComponent com_k2

Temps: 0.19 ms / 99.56 ms Mémoire: 0.046 MB / 12.24 MB Application: Before JAccess::preloadComponents (all components)

Temps: 1.34 ms / 100.89 ms Mémoire: 0.083 MB / 12.32 MB Application: After JAccess::preloadComponents (all components)

Temps: 0.05 ms / 100.94 ms Mémoire: 0.000 MB / 12.32 MB Application: Before JAccess::getAssetRules (id:66 name:com_k2)

Temps: 0.47 ms / 101.42 ms Mémoire: 0.045 MB / 12.36 MB Application: After JAccess::getAssetRules (id:66 name:com_k2)

Temps: 41.74 ms / 143.16 ms Mémoire: 5.092 MB / 17.45 MB Application: afterRenderComponent com_k2

Temps: 2.97 ms / 146.13 ms Mémoire: 0.193 MB / 17.65 MB Application: afterDispatch

Temps: 31.16 ms / 177.28 ms Mémoire: 1.561 MB / 19.21 MB Application: beforeRenderModule mod_menu (Footer Menu)

Temps: 2.41 ms / 179.69 ms Mémoire: 0.134 MB / 19.34 MB Application: afterRenderModule mod_menu (Footer Menu)

Temps: 0.10 ms / 179.79 ms Mémoire: 0.000 MB / 19.34 MB Application: beforeRenderModule mod_sp_simple_map (sp simple map )

Temps: 0.67 ms / 180.47 ms Mémoire: 0.014 MB / 19.35 MB Application: afterRenderModule mod_sp_simple_map (sp simple map )

Temps: 0.10 ms / 180.56 ms Mémoire: 0.000 MB / 19.35 MB Application: beforeRenderModule mod_custom (A propos de nous)

Temps: 0.91 ms / 181.47 ms Mémoire: 0.016 MB / 19.36 MB Application: afterRenderModule mod_custom (A propos de nous)

Temps: 0.09 ms / 181.57 ms Mémoire: 0.000 MB / 19.36 MB Application: beforeRenderModule mod_whosonline (Qui est en ligne)

Temps: 1.38 ms / 182.95 ms Mémoire: 0.051 MB / 19.41 MB Application: afterRenderModule mod_whosonline (Qui est en ligne)

Temps: 0.08 ms / 183.03 ms Mémoire: 0.002 MB / 19.42 MB Application: beforeRenderModule mod_k2_tools (Calendrier)

Temps: 4.55 ms / 187.58 ms Mémoire: 0.473 MB / 19.89 MB Application: afterRenderModule mod_k2_tools (Calendrier)

Temps: 0.10 ms / 187.67 ms Mémoire: 0.000 MB / 19.88 MB Application: beforeRenderModule mod_k2_content (Dernières actualités )

Temps: 8.50 ms / 196.17 ms Mémoire: 0.347 MB / 20.23 MB Application: afterRenderModule mod_k2_content (Dernières actualités )

Temps: 0.13 ms / 196.30 ms Mémoire: 0.000 MB / 20.17 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 1.12 ms / 197.42 ms Mémoire: 0.035 MB / 20.20 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 0.11 ms / 197.53 ms Mémoire: 0.000 MB / 20.20 MB Application: beforeRenderModule mod_search (Search)

Temps: 0.97 ms / 198.50 ms Mémoire: 0.021 MB / 20.22 MB Application: afterRenderModule mod_search (Search)

Temps: 0.13 ms / 198.63 ms Mémoire: 0.000 MB / 20.21 MB Application: beforeRenderModule mod_custom (Socials)

Temps: 0.25 ms / 198.88 ms Mémoire: 0.007 MB / 20.22 MB Application: afterRenderModule mod_custom (Socials)

Temps: 0.11 ms / 198.99 ms Mémoire: 0.000 MB / 20.22 MB Application: beforeRenderModule mod_custom (drapeau)

Temps: 0.28 ms / 199.27 ms Mémoire: 0.007 MB / 20.22 MB Application: afterRenderModule mod_custom (drapeau)

Temps: 42.55 ms / 241.81 ms Mémoire: 0.282 MB / 20.51 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

39 requêtes exécutées 32.51 ms

2 doubles découverts!

2 requêtes dupliquées: #28 #29

Temps de requête : 0.27 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.598 MB Rangées retournées : 0

SELECT `data`

  FROM `instm_session`

  WHERE `session_id` = 'v0soouv3f9o6stvo0obco4lhe7'

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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 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]

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

SELECT `session_id`

  FROM `instm_session`

  WHERE `session_id` = 'v0soouv3f9o6stvo0obco4lhe7' 
  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.01 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.01 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
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]

Temps de requête : 4.10 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.782 MB

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

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.12 ms
end	0.01 ms
query end	3.77 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 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]

Temps de requête : 0.39 ms Après la dernière requête : 2.02 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.080 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.01 ms
Opening tables	0.01 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.16 ms
end	0.01 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
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]

Temps de requête : 0.30 ms Après la dernière requête : 2.17 ms Mémoire de requête : 0.014 MB mémoire avant requête : 4.426 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.03 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 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
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]

Temps de requête : 0.39 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.015 MB mémoire avant requête : 4.450 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.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 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
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]

Temps de requête : 0.69 ms Après la dernière requête : 0.70 ms Mémoire de requête : 0.017 MB mémoire avant requête : 4.557 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.05 ms
checking permissions	0.01 ms
Opening tables	0.01 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.01 ms
Sending data	0.02 ms
Creating sort index	0.37 ms
end	0.01 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
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]

Temps de requête : 0.43 ms Après la dernière requête : 12.49 ms Mémoire de requête : 0.020 MB mémoire avant requête : 6.534 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.03 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.01 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
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]

Temps de requête : 0.29 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.016 MB mémoire avant requête : 6.560 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.01 ms
Opening tables	0.08 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.01 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
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]

Temps de requête : 0.28 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.017 MB mémoire avant requête : 6.665 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.03 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.01 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
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]

Temps de requête : 0.28 ms Après la dernière requête : 7.00 ms Mémoire de requête : 0.015 MB mémoire avant requête : 7.676 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.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.04 ms
end	0.01 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
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]

Temps de requête : 0.65 ms Après la dernière requête : 5.13 ms Mémoire de requête : 0.018 MB mémoire avant requête : 8.335 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.04 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.36 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	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
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]

Temps de requête : 0.40 ms Après la dernière requête : 3.08 ms Mémoire de requête : 0.027 MB mémoire avant requête : 8.819 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.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 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.01 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
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]

Temps de requête : 5.02 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.020 MB mémoire avant requête : 8.828 MB

UPDATE `instm_extensions`

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

  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.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.06 ms
end	0.01 ms
query end	4.68 ms
closing tables	0.02 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/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]

Temps de requête : 1.53 ms Après la dernière requête : 2.32 ms Mémoire de requête : 0.040 MB mémoire avant requête : 9.226 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.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.97 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 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]

Temps de requête : 0.48 ms Après la dernière requête : 1.08 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.473 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.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 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]

Temps de requête : 0.96 ms Après la dernière requête : 22.63 ms Mémoire de requête : 0.020 MB mémoire avant requête : 12.246 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.07 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.41 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 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]

Temps de requête : 0.53 ms Après la dernière requête : 10.32 ms Mémoire de requête : 0.019 MB mémoire avant requête : 14.226 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.04 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 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]

Temps de requête : 0.42 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.027 MB mémoire avant requête : 14.245 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.01 ms
Opening tables	0.10 ms
init	0.03 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.01 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
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]

Temps de requête : 0.74 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.380 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.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 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.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.05 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
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]

Temps de requête : 0.26 ms Après la dernière requête : 0.60 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.454 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 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.01 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
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]

Temps de requête : 0.55 ms Après la dernière requête : 2.24 ms Mémoire de requête : 0.020 MB mémoire avant requête : 14.689 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.01 ms
checking permissions	0.01 ms
Opening tables	0.22 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.03 ms
end	0.01 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
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]

Temps de requête : 0.27 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.021 MB mémoire avant requête : 14.712 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.01 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 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
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]

Temps de requête : 0.29 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.731 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.01 ms
Opening tables	0.13 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.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
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]

Temps de requête : 0.72 ms Après la dernière requête : 1.23 ms Mémoire de requête : 0.033 MB mémoire avant requête : 14.945 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.01 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.09 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
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.04 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
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]

Temps de requête : 0.40 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.028 MB mémoire avant requête : 15.012 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.17 ms
preparing	0.01 ms
executing	0.02 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 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]

Temps de requête : 0.67 ms Après la dernière requête : 3.28 ms Mémoire de requête : 0.025 MB mémoire avant requête : 15.962 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.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.18 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 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
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]

Temps de requête : 0.40 ms Après la dernière requête : 1.34 ms Mémoire de requête : 0.021 MB mémoire avant requête : 15.982 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.03 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 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
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]

Temps de requête : 0.21 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.003 MB Rangées retournées : 0

Requêtes dupliquées: #28

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.01 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.01 ms
end	0.01 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
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]

Temps de requête : 0.94 ms Après la dernière requête : 8.17 ms Mémoire de requête : 0.029 MB mémoire avant requête : 17.050 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.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 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
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
checking permissions	0.01 ms
checking permissions	0.01 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
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 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
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]

Temps de requête : 0.29 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.017 MB mémoire avant requête : 17.145 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.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.03 ms
updating	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 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/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]

Temps de requête : 0.49 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.021 MB mémoire avant requête : 17.162 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.01 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.03 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: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]

Temps de requête : 0.54 ms Après la dernière requête : 1.02 ms Mémoire de requête : 0.027 MB mémoire avant requête : 17.324 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 <= '2019-02-23 09:41:08' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-23 09:41:08' )  
  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.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 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]

Temps de requête : 0.53 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.027 MB mémoire avant requête : 17.354 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 <= '2019-02-23 09:41:08' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-23 09:41:08' )  
  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.05 ms
checking permissions	0.01 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.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 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]

Temps de requête : 0.53 ms Après la dernière requête : 4.29 ms Mémoire de requête : 0.015 MB mémoire avant requête : 17.475 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.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.24 ms
end	0.01 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
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]

Temps de requête : 1.86 ms Après la dernière requête : 21.70 ms Mémoire de requête : 0.025 MB mémoire avant requête : 19.084 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 <= '2019-02-23 09:41:08') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-23 09:41:08') 
  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.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.05 ms
System lock	0.02 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.01 ms
Creating sort index	0.97 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.02 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]

Temps de requête : 0.30 ms Après la dernière requête : 14.29 ms Mémoire de requête : 0.019 MB mémoire avant requête : 19.416 MB Rangées retournées : 34

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	34	10.00	Using where

Profil

Status	Duration
starting	0.04 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.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 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
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]

Temps de requête : 0.83 ms Après la dernière requête : 3.87 ms Mémoire de requête : 0.022 MB mémoire avant requête : 19.920 MB Rangées retournées : 0

SELECT DAY(created) AS day, COUNT(*) AS counter 
  FROM instm_k2_items 
  WHERE YEAR(created)=2019 
  AND MONTH(created)=2 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-23 09:41:08' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-23 09:41:08' ) 
  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.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.13 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.03 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]

Temps de requête : 4.12 ms Après la dernière requête : 2.60 ms Mémoire de requête : 0.027 MB mémoire avant requête : 20.136 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 <= '2019-02-23 09:41:08' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-23 09:41:08' ) 
  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.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	3.32 ms
Creating sort index	0.14 ms
end	0.02 ms
query end	0.01 ms
removing tmp table	0.08 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 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]

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

Tables sélectionnées :

```
3 × SELECT * 
  FROM instm_k2_items
```

2 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM instm_k2_users

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

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `instm_usergroups` AS g 
  INNER JOIN `instm_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `instm_users`
```

1 × SELECT tag.*   
  FROM instm_k2_tags AS tag   JOIN instm_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

1 × SELECT * 
  FROM instm_k2_attachments

```
1 × SELECT * 
  FROM instm_k2_rating
```

1 × SELECT * 
  FROM instm_k2_comments

1 × SELECT DAY(created) AS day, COUNT(*) AS counter 
  FROM instm_k2_items

1 × 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

1 × SELECT guest, client_id 
  FROM instm_session

1 × 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

1 × SELECT language,id 
  FROM `instm_menu`

1 × SELECT * 
  FROM instm_k2_categories

1 × SELECT id 
  FROM instm_k2_categories

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM instm_extensions

```
1 × SELECT * 
  FROM instm_languages
```

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

1 × SELECT id, rules 
  FROM `instm_viewlevels

1 × SELECT `session_id` 
  FROM `instm_session`

1 × SELECT * 
  FROM `instm_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `instm_admintools_storage`

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

1 × 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

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

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `instm_extensions`

1 × SELECT `data` 
  FROM `instm_session`

Autres tables :

1 × SHOW FULL COLUMNS 
  FROM `instm_k2_items

1 × UPDATE instm_k2_items 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `instm_users

1 × SHOW FULL COLUMNS 
  FROM `instm_k2_categories

1 × SHOW VARIABLES LIKE "collation_database

1 × UPDATE `instm_extensions` 
  SET `params` = '{\"mediaversion\":\"cca5e5512054d44980894b95da137882\"}'

1 × INSERT INTO `instm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('v0soouv3f9o6stvo0obco4lhe7', 1, '1550914868', 0, '', 0

La visite d'une délégation russe

Liste et Prix des Analyses...

La visite d'une délégation russe...

Session de formation...

A propos de nous

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

39 requêtes exécutées 32.51 ms

2 doubles découverts!

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

Tables sélectionnées :

Autres tables :