Recherche

ES - INSA

Excellence Sportive

Vue du menu de recherche

Menu

Le Cann Guillaume

Hand Ball

Département : SRC
Année d'étude : 5ème Année

Classement : non classé(e)

Guillaume.Le-Cann@insa-rennes.fr









Console de débogage Joomla!

Session

Profil d'information

Occupation de la mémoire

Requêtes de base de données

SELECT `session_id`

  FROM `jos_session`
  WHERE `session_id` = 'bd99c8e8de822e4e736a9c7ec2c1a56c'
  LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEjos_sessionconstPRIMARYPRIMARY766const1Using index
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
ROOT/index.php:46
#CallerFile and line number
8JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1730
7JDatabaseDriver->loadResult()JROOT/libraries/src/Application/CMSApplication.php:178
6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:833
5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:133
4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:415
2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
1Joomla\CMS\Factory::getApplication()

  • Temps de requête : 4.64 ms Après la dernière requête : 0.20 ms
    INSERT INTO `jos_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('bd99c8e8de822e4e736a9c7ec2c1a56c', 1, '1511278535', 0, '', 0)
    EXPLAIN impossible sur la requête : INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('bd99c8e8de822e4e736a9c7ec2c1a56c', 1, '1511278535', 0, '', 0)
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    update0.03 ms
    Waiting for query cache lock0.00 ms
    update0.00 ms
    end0.00 ms
    query end4.51 ms
    closing tables0.01 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    7JDatabaseDriverMysql->execute()JROOT/libraries/src/Application/CMSApplication.php:218
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:833
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:133
    4Joomla\CMS\Application\CMSA0plicAtinn->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:415
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46

  • Temps de requête : 0.29 ms Après la dernière requête : 3.06 ms
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jos_extensions`
      WHERE `type` = 'component'
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_extensionsrefextensionextension82const38Using where
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.13 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    12JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1691
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:422
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:430
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:496
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:596
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.12 ms Après la dernière requête : 2.48 ms
    SELECT id, rules
    
      FROM `jos_viewlevels`
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_viewlevelsALLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULL6
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.00 ms
    preparing0.00 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    10JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1496
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:310
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:606
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.17 ms Après la dernière requête : 0.14 ms
    SELECT b.id
    
      FROM jos_usergroups AS a
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2Using where; Using index
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    11JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1540
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:310
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:606
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.54 ms Après la dernière requête : 0.71 ms
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM jos_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1)
      ORDER BY ordering
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_extensionsrefextensionextension82const88Using where; Utilisation du tri complet de type filesort
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.21 ms
    Sending data0.16 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    11JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1691
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:343
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:348
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:606
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.53 ms Après la dernière requête : 32.51 ms
    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 jos_menu AS m
      LEFT JOIN jos_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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const28Using where; Utilisation du tri complet de type filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4exlsport_jos1.m.component_id1
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.10 ms
    Sending data0.17 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    19JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1691
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:446
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:64
    8Joomla\CMS\Router\Siteoute2-&et;__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:551
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:405
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1146
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:798
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.18 ms Après la dernière requête : 8.01 ms
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jos_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using where
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    15JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1652
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1116
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 5.15 ms Après la dernière requête : 0.22 ms
    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"995c00fb896f046987da010e021d016d\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    EXPLAIN impossible sur la requête : UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"995c00fb896f046987da010e021d016d\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.04 ms
    Updating0.04 ms
    end0.00 ms
    Waiting for query cache lock0.00 ms
    end0.00 ms
    query end4.99 ms
    closing tables0.01 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    10JDatabaseDriverMysql->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1116
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.19 ms Après la dernière requête : 2.03 ms
    SELECT *
    
      FROM jos_languages
      WHERE published=1
      ORDER BY ordering ASC
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_languagesALLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULL2Using where; Utilisation du tri complet de type filesort
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.02 ms
    Sending data0.05 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    7JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1691
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.23 ms Après la dernière requête : 0.33 ms
    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
      LEFT JOIN jos_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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_templateINDEX N'A PU ÊTRE UTILISÉNULLNULL9Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403exlsport_jos1.s.template,const1Using where
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.06 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    6JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1691
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:488
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.36 ms Après la dernière requête : 6.81 ms
    SELECT sf.id,u.username,u.name,sf.prenom,u.email,sf.affMail,photo,s.nomSport,specialite,nomClassement,a.annee,nomDepartement,listeJeuneSport,emploiTps,niveau,objectif,volumeEntrainement,entraineur,compet,cl.nomClub as clubEntrain,clu.nomClub,sf.annee AS diplome,sf.entreprise
    
      FROM jos_sportif AS sf
      INNER JOIN jos_sport AS s
      ON idSport=s.id
      INNER JOIN jos_classement as c
      ON sf.idClassement=c.id
      INNER JOIN jos_departement as d
      ON sf.idDepartement=d.id
      INNER JOIN jos_club AS cl
      ON cl.id=sf.idClubEntrainement
      INNER JOIN jos_club AS clu
      ON clu.id=sf.idClubCompet
      INNER JOIN jos_annee AS a
      ON sf.an=a.id
      INNER JOIN jos_users AS u
      ON u.username=sf.username
      WHERE sf.id=56
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsfconstPRIMARY,idSport,idClassement,idClubEntrainement,idClubCompet,an,idDepartementPRIMARY4const1
    1SIMPLEsconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEdconstPRIMARYPRIMARY4const1
    1SIMPLEclconstPRIMARYPRIMARY4const1
    1SIMPLEcluconstPRIMARYPRIMARY4const1
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEurefusernameusername602const1Using where
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.04 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    15JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1652
    14JDatabaseDriver->loadObject()JROOT/components/com_sportif/models/sportif.php:87
    13SportifModelSportif->getSportif()JROOT/components/com_sportif/models/sportif.php:48
    12SportifModelSportif->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:423
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_sportif/views/sportif/view.html.php:25
    10SportifViewSportif->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_sportif/controller.php:48
    8SportifController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_sportif/sportif.php:21
    6require_once JROOT/components/com_sportif/sportif.phpJROOT/libraries/src/Component/ComponentHelper.php:381
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:356
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.18 ms Après la dernière requête : 0.13 ms
    SELECT u.id
    
      FROM jos_sportif AS sf
      INNER JOIN jos_users AS u
      ON u.username=sf.username
      WHERE sf.id="56"
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsfconstPRIMARYPRIMARY4const1
    1SIMPLEurefusernameusername602const1Using where; Using index
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    14JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1730
    13JDatabaseDriver->loadResult()JROOT/components/com_sportif/models/sportif.php:106
    12SportifModelSportif->getArticles()JROOT/libraries/src/MVC/View/HtmlView.php:423
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_sportif/views/sportif/view.html.php:26
    10SportifViewSportif->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_sportif/controller.php:48
    8SportifController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_sportif/sportif.php:21
    6require_once JROOT/components/com_sportif/sportif.phpJROOT/libraries/src/Component/ComponentHelper.php:381
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:356
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.19 ms Après la dernière requête : 0.10 ms
    SELECT *
    
      FROM jos_content
      WHERE created_by='99'
      ORDER BY created DESC
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_contentrefidx_createdbyidx_createdby4const1Using where; Utilisation du tri complet de type filesort
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.02 ms
    optimizing0.00 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.02 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    14JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1691
    13JDatabaseDriver->loadObjectList()JROOT/components/com_sportif/models/sportif.php:115
    12SportifModelSportif->getArticles()JROOT/libraries/src/MVC/View/HtmlView.php:423
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_sportif/views/sportif/view.html.php:26
    10SportifViewSportif->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_sportif/controller.php:48
    8SportifController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_sportif/sportif.php:21
    6require_once JROOT/components/com_sportif/sportif.phpJROOT/libraries/src/Component/ComponentHelper.php:381
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:356
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

  • Temps de requête : 0.38 ms Après la dernière requête : 6.60 ms
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_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 <= '2017-11-21 15:35:35')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-11-21 15:35:35')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 135 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const7Using where; Utilisation du tri complet de type filesort
    1SIMPLEmmrefPRIMARYPRIMARY4exlsport_jos1.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403exlsport_jos1.m.module,const1Using where
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.05 ms
    Sending data0.08 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    15JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1691
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:433
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:363
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:581
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/insatheme/index.php:13
    7require JROOT/templates/insatheme/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1103
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49

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

    Tables sélectionnées :
    1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
        FROM `jos_extensions`
    2. 1 × SELECT sf.id,u.username,u.name,sf.prenom,u.email,sf.affMail,photo,s.nomSport,specialite,nomClassement,a.annee,nomDepartement,listeJeuneSport,emploiTps,niveau,objectif,volumeEntrainement,entraineur,compet,cl.nomClub as clubEntrain,clu.nomClub,sf.annee AS diplome,sf.entreprise 
        FROM jos_sportif AS sf
        INNER JOIN jos_sport AS s
        ON idSport=s.id
        INNER JOIN jos_classement as c
        ON sf.idClassement=c.id
        INNER JOIN jos_departement as d
        ON sf.idDepartement=d.id
        INNER JOIN jos_club AS cl
        ON cl.id=sf.idClubEntrainement
        INNER JOIN jos_club AS clu
        ON clu.id=sf.idClubCompet
        INNER JOIN jos_annee AS a
        ON sf.an=a.id
        INNER JOIN jos_users AS u
        ON u.username=sf.username
    3. 1 × SELECT id, home, template, s.params 
        FROM jos_template_styles as s
        LEFT JOIN jos_extensions as e
        ON e.element=s.template
        AND e.type='template'
        AND e.client_id=s.client_id
    4. 1 × SELECT u.id 
        FROM jos_sportif AS sf
        INNER JOIN jos_users AS u
        ON u.username=sf.username
    5. 1 × SELECT * 
        FROM jos_content
    6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
        FROM jos_modules AS m
        LEFT JOIN jos_modules_menu AS mm
        ON mm.moduleid = m.id
        LEFT JOIN jos_extensions AS e
        ON e.element = m.module
        AND e.client_id = m.client_id
    7. 1 × SELECT * 
        FROM jos_languages
    8. 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 jos_menu AS m
        LEFT JOIN jos_extensions AS e
        ON m.component_id = e.extension_id
    9. 1 × SELECT `session_id` 
        FROM `jos_session`
    10. 1 × SELECT id, rules 
        FROM `jos_viewlevels
    11. 1 × SELECT b.id 
        FROM jos_usergroups AS a
        LEFT JOIN jos_usergroups AS b
        ON b.lft <= a.lft
        AND b.rgt >= a.rgt
    12. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
        FROM jos_extensions
    13. 1 × SELECT `data` 
        FROM `jos_session`
    Autres tables :
    1. 1 × UPDATE `jos_extensions` 
        SET `params` = '{\"mediaversion\":\"995c00fb896f046987da010e021d016d\"}'
    2. 1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
        VALUES ('bd99c8e8de822e4e736a9c7ec2c1a56c', 1, '1511278535', 0, '', 0
    3. 1 × DELETE  
        FROM `jos_session`