Recherche

ES - INSA

Excellence Sportive

Vue du menu de recherche

Menu

Lambart Pierre

Basket Ball

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

Classement : non classé(e)

Pierre.Lambart@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 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.01 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.64 ms Après la dernière requête : 6.83 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=234
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsfconstPRIMARY,idSport,idClassement,idClubEntrainement,idClubCompet,an,idDepartementPRIMARY4const1
    1SIMPLEsconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEdconstPRIMARYPRIMARY4const1
    1SIMPLEclconstPRIMARYPRIMARY4const1
    1SIMPLEcluconstPRIMARYPRIMARY4const1
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEurefusernameusername602const1Using where
    StatusDuration
    starting0.07 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.03 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 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.17 ms Après la dernière requête : 0.14 ms
    SELECT u.id
    
      FROM jos_sportif AS sf
      INNER JOIN jos_users AS u
      ON u.username=sf.username
      WHERE sf.id="234"
    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.03 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.18 ms Après la dernière requête : 0.10 ms
    SELECT *
    
      FROM jos_content
      WHERE created_by='239'
      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.67 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-24 00:21:28')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-11-24 00:21:28')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 133 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.06 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

  • 15 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\":\"28bac8158667c6b6430c2b27c1dbdd15\"}'
    2. 1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
        VALUES ('0f8616e26a892def9bc6a8ccdaf48634', 1, '1511482888', 0, '', 0