Console de débogage Joomla!

Requêtes de base de données

38 requêtes exécutées 76.15 ms

6 doubles découverts!
2 requêtes dupliquées: #3  #37
2 requêtes dupliquées: #4  #38
2 requêtes dupliquées: #22  #23
1. Temps de requête : 0.59 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.960 MB Rangées retournées : 1
2. SELECT `data`
3. 
  FROM `sygjw_session`

  WHERE `session_id` = 'eecc75be0ee6253550dfa48b838a3909'
Explication
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
sygjw_session
const
PRIMARY
PRIMARY
194
const
1

Profil
Status
Duration
starting
0.03 ms
checking permissions
0.01 ms
Opening tables
0.01 ms
System lock
0.02 ms
init
0.01 ms
optimizing
0.01 ms
statistics
0.06 ms
preparing
0.01 ms
executing
0.00 ms
Sending data
0.01 ms
end
0.00 ms
query end
0.00 ms
closing tables
0.01 ms
freeing items
0.02 ms
logging slow query
0.00 ms
cleaning up
0.00 ms
Pile d'appels
#
Appel
Fichier et numéro de ligne
16
JDatabaseDriverMysqli->execute()
JROOT/libraries/joomla/database/driver.php:1734
15
JDatabaseDriver->loadResult()
JROOT/libraries/joomla/session/storage/database.php:45
14
JSessionStorageDatabase->read()
Même appel que celui de la ligne ci-dessous.
13
session_start()
JROOT/libraries/joomla/session/handler/native.php:260
12
JSessionHandlerNative->doSessionStart()
JROOT/libraries/joomla/session/handler/native.php:50
11
JSessionHandlerNative->start()
JROOT/libraries/joomla/session/handler/joomla.php:88
10
JSessionHandlerJoomla->start()
JROOT/libraries/src/Session/Session.php:660
9
Joomla\CMS\Session\Session->_start()
JROOT/libraries/src/Session/Session.php:620
8
Joomla\CMS\Session\Session->start()
JROOT/libraries/src/Session/Session.php:498
7
Joomla\CMS\Session\Session->get()
JROOT/libraries/src/Session/Session.php:455
6
Joomla\CMS\Session\Session->isNew()
JROOT/libraries/src/Application/CMSApplication.php:758
5
Joomla\CMS\Application\CMSApplication->loadSession()
JROOT/libraries/src/Application/CMSApplication.php:135
4
Joomla\CMS\Application\CMSApplication->__construct()
JROOT/libraries/src/Application/SiteApplication.php:66
3
Joomla\CMS\Application\SiteApplication->__construct()
JROOT/libraries/src/Application/CMSApplication.php:344
2
Joomla\CMS\Application\CMSApplication::getInstance()
JROOT/libraries/src/Factory.php:140
1
Joomla\CMS\Factory::getApplication()
JROOT/index.php:46
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

4. Temps de requête : 18.01 ms Après la dernière requête : 3.57 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.315 MB Rangées retournées : 16
SHOW FULL COLUMNS 
  FROM `sygjw_users`
Explication
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `sygjw_users`
Profil
Status
Duration
starting
0.04 ms
checking permissions
0.01 ms
Opening tables
11.52 ms
System lock
0.02 ms
init
0.01 ms
optimizing
0.00 ms
statistics
0.01 ms
preparing
0.01 ms
executing
0.01 ms
Opening tables
0.01 ms
checking permissions
0.03 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
checking permissions
0.01 ms
Sending data
0.05 ms
end
0.01 ms
query end
0.00 ms
closing tables
0.00 ms
removing tmp table
1.07 ms
closing tables
0.01 ms
freeing items
0.10 ms
logging slow query
0.01 ms
cleaning up
0.01 ms
Pile d'appels
#
Appel
Fichier et numéro de ligne
20
JDatabaseDriverMysqli->execute()
JROOT/libraries/joomla/database/driver.php:1695
19
JDatabaseDriver->loadObjectList()
JROOT/libraries/joomla/database/driver/mysqli.php:445
18
JDatabaseDriverMysqli->getTableColumns()
JROOT/libraries/src/Table/Table.php:245
17
Joomla\CMS\Table\Table->getFields()
JROOT/libraries/src/Table/Table.php:164
16
Joomla\CMS\Table\Table->__construct()
JROOT/libraries/src/Table/User.php:40
15
Joomla\CMS\Table\User->__construct()
JROOT/libraries/src/Table/Table.php:312
14
Joomla\CMS\Table\Table::getInstance()
JROOT/libraries/src/User/User.php:603
13
Joomla\CMS\User\User::getTable()
JROOT/libraries/src/User/User.php:880
12
Joomla\CMS\User\User->load()
JROOT/libraries/src/User/User.php:946
11
Joomla\CMS\User\User->__wakeup()
Même appel que celui de la ligne ci-dessous.
10
unserialize()
JROOT/libraries/src/Session/Session.php:670
9
Joomla\CMS\Session\Session->_start()
JROOT/libraries/src/Session/Session.php:620
8
Joomla\CMS\Session\Session->start()
JROOT/libraries/src/Session/Session.php:498
7
Joomla\CMS\Session\Session->get()
JROOT/libraries/src/Session/Session.php:455
6
Joomla\CMS\Session\Session->isNew()
JROOT/libraries/src/Application/CMSApplication.php:758
5
Joomla\CMS\Application\CMSApplication->loadSession()
JROOT/libraries/src/Application/CMSApplication.php:135
4
Joomla\CMS\Application\CMSApplication->__construct()
JROOT/libraries/src/Application/SiteApplication.php:66
3
Joomla\CMS\Application\SiteApplication->__construct()
JROOT/libraries/src/Application/CMSApplication.php:344
2
Joomla\CMS\Application\CMSApplication::getInstance()
JROOT/libraries/src/Factory.php:140
1
Joomla\CMS\Factory::getApplication()
JROOT/index.php:46
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

5. Temps de requête : 4.66 ms Après la dernière requête : 0.77 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.356 MB Rangées retournées : 1
Requêtes dupliquées: #37
SELECT *

  FROM `sygjw_users`

  WHERE `id` = 990
Explication
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
sygjw_users
const
PRIMARY
PRIMARY
4
const
1

Profil
Status
Duration
starting
0.03 ms
checking permissions
0.01 ms
Opening tables
0.01 ms
System lock
0.01 ms
init
0.02 ms
optimizing
0.01 ms
statistics
0.04 ms
preparing
0.01 ms
executing
0.00 ms
Sending data
0.02 ms
end
0.00 ms
query end
0.00 ms
closing tables
0.01 ms
freeing items
0.09 ms
logging slow query
0.01 ms
cleaning up
0.00 ms
Pile d'appels
#
Appel
Fichier et numéro de ligne
15
JDatabaseDriverMysqli->execute()
JROOT/libraries/joomla/database/driver.php:1459
14
JDatabaseDriver->loadAssoc()
JROOT/libraries/src/Table/User.php:86
13
Joomla\CMS\Table\User->load()
JROOT/libraries/src/User/User.php:883
12
Joomla\CMS\User\User->load()
JROOT/libraries/src/User/User.php:946
11
Joomla\CMS\User\User->__wakeup()
Même appel que celui de la ligne ci-dessous.
10
unserialize()
JROOT/libraries/src/Session/Session.php:670
9
Joomla\CMS\Session\Session->_start()
JROOT/libraries/src/Session/Session.php:620
8
Joomla\CMS\Session\Session->start()
JROOT/libraries/src/Session/Session.php:498
7
Joomla\CMS\Session\Session->get()
JROOT/libraries/src/Session/Session.php:455
6
Joomla\CMS\Session\Session->isNew()
JROOT/libraries/src/Application/CMSApplication.php:758
5
Joomla\CMS\Application\CMSApplication->loadSession()
JROOT/libraries/src/Application/CMSApplication.php:135
4
Joomla\CMS\Application\CMSApplication->__construct()
JROOT/libraries/src/Application/SiteApplication.php:66
3
Joomla\CMS\Application\SiteApplication->__construct()
JROOT/libraries/src/Application/CMSApplication.php:344
2
Joomla\CMS\Application\CMSApplication::getInstance()
JROOT/libraries/src/Factory.php:140
1
Joomla\CMS\Factory::getApplication()
JROOT/index.php:46
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

6. Temps de requête : 1.11 ms Après la dernière requête : 3.36 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.919 MB Rangées retournées : 1
Requêtes dupliquées: #38
SELECT `g`.`id`,`g`.`title`

  FROM `sygjw_usergroups` AS g

  INNER JOIN `sygjw_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 990
Explication
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
m
ref
PRIMARY
PRIMARY
4
const
1
Using index
1
SIMPLE
g
eq_ref
PRIMARY
PRIMARY
4
cnmbploncnmb2019.m.group_id
1

Profil
Status
Duration
starting
0.03 ms
checking permissions
0.00 ms
checking permissions
0.00 ms
Opening tables
0.01 ms
System lock
0.01 ms
init
0.01 ms
optimizing
0.01 ms
statistics
0.03 ms
preparing
0.01 ms
executing
0.00 ms
Sending data
0.09 ms
end
0.01 ms
query end
0.01 ms
closing tables
0.01 ms
freeing items
0.07 ms
logging slow query
0.01 ms
cleaning up
0.00 ms
Pile d'appels
#
Appel
Fichier et numéro de ligne
15
JDatabaseDriverMysqli->execute()
JROOT/libraries/joomla/database/driver.php:1500
14
JDatabaseDriver->loadAssocList()
JROOT/libraries/src/Table/User.php:111
13
Joomla\CMS\Table\User->load()
JROOT/libraries/src/User/User.php:883
12
Joomla\CMS\User\User->load()
JROOT/libraries/src/User/User.php:946
11
Joomla\CMS\User\User->__wakeup()
Même appel que celui de la ligne ci-dessous.
10
unserialize()
JROOT/libraries/src/Session/Session.php:670
9
Joomla\CMS\Session\Session->_start()
JROOT/libraries/src/Session/Session.php:620
8
Joomla\CMS\Session\Session->start()
JROOT/libraries/src/Session/Session.php:498
7
Joomla\CMS\Session\Session->get()
JROOT/libraries/src/Session/Session.php:455
6
Joomla\CMS\Session\Session->isNew()
JROOT/libraries/src/Application/CMSApplication.php:758
5
Joomla\CMS\Application\CMSApplication->loadSession()
JROOT/libraries/src/Application/CMSApplication.php:135
4
Joomla\CMS\Application\CMSApplication->__construct()
JROOT/libraries/src/Application/SiteApplication.php:66
3
Joomla\CMS\Application\SiteApplication->__construct()
JROOT/libraries/src/Application/CMSApplication.php:344
2
Joomla\CMS\Application\CMSApplication::getInstance()
JROOT/libraries/src/Factory.php:140
1
Joomla\CMS\Factory::getApplication()
JROOT/index.php:46
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

7. Temps de requête : 0.52 ms Après la dernière requête : 2.31 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.038 MB Rangées retournées : 5
8. SELECT id, rules

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

Profil
Status
Duration
starting
0.02 ms
checking permissions
0.01 ms
Opening tables
0.01 ms
System lock
0.01 ms
init
0.01 ms
optimizing
0.00 ms
statistics
0.01 ms
preparing
0.01 ms
executing
0.00 ms
Sending data
0.03 ms
end
0.00 ms
query end
0.00 ms
closing tables
0.01 ms
freeing items
0.08 ms
logging slow query
0.01 ms
cleaning up
0.01 ms
Pile d'appels
#
Appel
Fichier et numéro de ligne
10
JDatabaseDriverMysqli->execute()
JROOT/libraries/joomla/database/driver.php:1500
9
JDatabaseDriver->loadAssocList()
JROOT/libraries/src/Access/Access.php:1063
8
Joomla\CMS\Access\Access::getAuthorisedViewLevels()
JROOT/libraries/src/User/User.php:458
7
Joomla\CMS\User\User->getAuthorisedViewLevels()
JROOT/libraries/src/Plugin/PluginHelper.php:321
6
Joomla\CMS\Plugin\PluginHelper::load()
JROOT/libraries/src/Plugin/PluginHelper.php:87
5
Joomla\CMS\Plugin\PluginHelper::getPlugin()
JROOT/libraries/src/Plugin/PluginHelper.php:129
4
Joomla\CMS\Plugin\PluginHelper::isEnabled()
JROOT/libraries/src/Application/SiteApplication.php:604
3
Joomla\CMS\Application\SiteApplication->initialiseApp()
JROOT/libraries/src/Application/SiteApplication.php:212
2
Joomla\CMS\Application\SiteApplication->doExecute()
JROOT/libraries/src/Application/CMSApplication.php:196
1
Joomla\CMS\Application\CMSApplication->execute()
JROOT/index.php:49
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

9. Temps de requête : 0.79 ms Après la dernière requête : 2.38 ms Mémoire de requête : 0.033 MB mémoire avant requête : 4.209 MB Rangées retournées : 35
10. SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
11. 
  FROM `sygjw_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1
Explication
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
sygjw_extensions
ref
extension
extension
82
const
35
Using where
Profil
Status
Duration
starting
0.03 ms
checking permissions
0.01 ms
Opening tables
0.01 ms
System lock
0.01 ms
init
0.01 ms
optimizing
0.01 ms
statistics
0.03 ms
preparing
0.01 ms
executing
0.00 ms
Sending data
0.14 ms
end
0.01 ms
query end
0.00 ms
closing tables
0.01 ms
freeing items
0.13 ms
logging slow query
0.01 ms
cleaning up
0.01 ms
Pile d'appels
#
Appel
Fichier et numéro de ligne
18
JDatabaseDriverMysqli->execute()
JROOT/libraries/joomla/database/driver.php:1695
17
JDatabaseDriver->loadObjectList()
JROOT/libraries/src/Component/ComponentHelper.php:445
16
Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()
Même appel que celui de la ligne ci-dessous.
15
call_user_func_array()
JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14
Joomla\CMS\Cache\Controller\CallbackController->get()
JROOT/libraries/src/Component/ComponentHelper.php:453
13
Joomla\CMS\Component\ComponentHelper::load()
JROOT/libraries/src/Component/ComponentHelper.php:519
12
Joomla\CMS\Component\ComponentHelper::getComponents()
JROOT/libraries/src/Component/ComponentHelper.php:44
11
Joomla\CMS\Component\ComponentHelper::getComponent()
JROOT/libraries/src/Component/ComponentHelper.php:103
10
Joomla\CMS\Component\ComponentHelper::getParams()
JROOT/libraries/src/Access/Access.php:939
9
Joomla\CMS\Access\Access::getGroupsByUser()
JROOT/libraries/src/Access/Access.php:1095
8
Joomla\CMS\Access\Access::getAuthorisedViewLevels()
JROOT/libraries/src/User/User.php:458
7
Joomla\CMS\User\User->getAuthorisedViewLevels()
JROOT/libraries/src/Plugin/PluginHelper.php:321
6
Joomla\CMS\Plugin\PluginHelper::load()
JROOT/libraries/src/Plugin/PluginHelper.php:87
5
Joomla\CMS\Plugin\PluginHelper::getPlugin()
JROOT/libraries/src/Plugin/PluginHelper.php:129
4
Joomla\CMS\Plugin\PluginHelper::isEnabled()
JROOT/libraries/src/Application/SiteApplication.php:604
3
Joomla\CMS\Application\SiteApplication->initialiseApp()
JROOT/libraries/src/Application/SiteApplication.php:212
2
Joomla\CMS\Application\SiteApplication->doExecute()
JROOT/libraries/src/Application/CMSApplication.php:196
1
Joomla\CMS\Application\CMSApplication->execute()
JROOT/index.php:49
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

12. Temps de requête : 0.48 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.260 MB Rangées retournées : 2
13. SELECT b.id
14. 
  FROM sygjw_user_usergroup_map AS map
15. 
  LEFT JOIN sygjw_usergroups AS a 
  ON a.id = map.group_id
16. 
  LEFT JOIN sygjw_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE map.user_id = 990
Explication
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
map
ref
PRIMARY
PRIMARY
4
const
1
Using index
1
SIMPLE
a
eq_ref
PRIMARY
PRIMARY
4
cnmbploncnmb2019.map.group_id
1

1
SIMPLE
b
index
idx_usergroup_nested_set_lookup
idx_usergroup_nested_set_lookup
8
NULL
9
Using index
Profil
Status
Duration
starting
0.03 ms
checking permissions
0.01 ms
checking permissions
0.00 ms
checking permissions
0.00 ms
Opening tables
0.01 ms
System lock
0.01 ms
init
0.01 ms
optimizing
0.01 ms
statistics
0.03 ms
preparing
0.01 ms
executing
0.00 ms
Sending data
0.03 ms
end
0.01 ms
query end
0.00 ms
closing tables
0.01 ms
freeing items
0.07 ms
logging slow query
0.01 ms
cleaning up
0.00 ms
Pile d'appels
#
Appel
Fichier et numéro de ligne
11
JDatabaseDriverMysqli->execute()
JROOT/libraries/joomla/database/driver.php:1544
10
JDatabaseDriver->loadColumn()
JROOT/libraries/src/Access/Access.php:980
9
Joomla\CMS\Access\Access::getGroupsByUser()
JROOT/libraries/src/Access/Access.php:1095
8
Joomla\CMS\Access\Access::getAuthorisedViewLevels()
JROOT/libraries/src/User/User.php:458
7
Joomla\CMS\User\User->getAuthorisedViewLevels()
JROOT/libraries/src/Plugin/PluginHelper.php:321
6
Joomla\CMS\Plugin\PluginHelper::load()
JROOT/libraries/src/Plugin/PluginHelper.php:87
5
Joomla\CMS\Plugin\PluginHelper::getPlugin()
JROOT/libraries/src/Plugin/PluginHelper.php:129
4
Joomla\CMS\Plugin\PluginHelper::isEnabled()
JROOT/libraries/src/Application/SiteApplication.php:604
3
Joomla\CMS\Application\SiteApplication->initialiseApp()
JROOT/libraries/src/Application/SiteApplication.php:212
2
Joomla\CMS\Application\SiteApplication->doExecute()
JROOT/libraries/src/Application/CMSApplication.php:196
1
Joomla\CMS\Application\CMSApplication->execute()
JROOT/index.php:49
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

17. Temps de requête : 1.71 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.321 MB Rangées retournées : 83
18. SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
19. 
  FROM sygjw_extensions
20. 
  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,2,3,6)

  ORDER BY ordering
Explication
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
sygjw_extensions
ALL
extension
INDEX N'A PU ÊTRE UTILISÉ
NULL
NULL
134
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
System lock
0.01 ms
init
0.02 ms
optimizing
0.01 ms
statistics
0.04 ms
preparing
0.02 ms
executing
0.01 ms
Sorting result
0.26 ms
Sending data
0.55 ms
end
0.01 ms
query end
0.01 ms
closing tables
0.01 ms
freeing items
0.13 ms
logging slow query
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:1695
10
JDatabaseDriver->loadObjectList()
JROOT/libraries/src/Plugin/PluginHelper.php:354
9
Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()
Même appel que celui de la ligne ci-dessous.
8
call_user_func_array()
JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7
Joomla\CMS\Cache\Controller\CallbackControlle