Recherche

ES - INSA

Excellence Sportive

Vue du menu de recherche

Menu

Cotten Yvon

Roller skating

Département : GMA
Année d'étude : Ingénieur Diplomé en 2003

Classement : Ancien Sportif

ycotten@yahoo.fr

Entreprise :









Console de débogage Joomla!

Session

Profil d'information

Occupation de la mémoire

Requêtes de base de données


  • Temps de requête : 0.17 ms Après la dernière requête : 1.77 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.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
    7JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    6JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:148
    5JLanguageHelper::getLanguages()JROOT/libraries/cms/application/site.php:327
    4JApplicationSite->getParams()JROOT/libraries/cms/application/site.php:135
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49

  • Temps de requête : 0.23 ms Après la dernière requête : 0.31 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.02 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:1681
    5JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:485
    4JApplicationSite->getTemplate()JROOT/libraries/cms/application/site.php:165
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49

  • Temps de requête : 0.34 ms Après la dernière requête : 6.15 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=102
    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.03 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 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:1642
    14JDatabaseDriver->loadObject()JROOT/components/com_sportif/models/sportif.php:87
    13SportifModelSportif->getSportif()JROOT/components/com_sportif/models/sportif.php:48
    12SportifModelSportif->getItems()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_sportif/views/sportif/view.html.php:25
    10SportifViewSportif->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_sportif/controller.php:48
    8SportifController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_sportif/sportif.php:21
    6require_once JROOT/components/com_sportif/sportif.phpJROOT/libraries/cms/component/helper.php:389
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:364
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49

  • Temps de requête : 0.17 ms Après la dernière requête : 0.12 ms
    SELECT u.id
    
      FROM jos_sportif AS sf
      INNER JOIN jos_users AS u
      ON u.username=sf.username
      WHERE sf.id="102"
    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:1720
    13JDatabaseDriver->loadResult()JROOT/components/com_sportif/models/sportif.php:106
    12SportifModelSportif->getArticles()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_sportif/views/sportif/view.html.php:26
    10SportifViewSportif->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_sportif/controller.php:48
    8SportifController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_sportif/sportif.php:21
    6require_once JROOT/components/com_sportif/sportif.phpJROOT/libraries/cms/component/helper.php:389
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:364
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->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='142'
      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:1681
    13JDatabaseDriver->loadObjectList()JROOT/components/com_sportif/models/sportif.php:115
    12SportifModelSportif->getArticles()JROOT/libraries/legacy/view/legacy.php:422
    11JViewLegacy->get()JROOT/components/com_sportif/views/sportif/view.html.php:26
    10SportifViewSportif->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_sportif/controller.php:48
    8SportifController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_sportif/sportif.php:21
    6require_once JROOT/components/com_sportif/sportif.phpJROOT/libraries/cms/component/helper.php:389
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:364
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49

  • Temps de requête : 0.41 ms Après la dernière requête : 6.23 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-18 23:33:36')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-11-18 23:33:36')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 138 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.02 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.00 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    15JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:169
    12JCacheControllerCallback->get()JROOT/libraries/cms/module/helper.php:424
    11JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:360
    10JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    9JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:576
    8JDocumentHtml->countModules()JROOT/templates/insatheme/index.php:13
    7require JROOT/templates/insatheme/index.phpJROOT/libraries/joomla/document/html.php:653
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:715
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:530
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1102
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->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` 
        FROM jos_extensions
    13. 1 × SELECT `data` 
        FROM `jos_session`
    Autres tables :
    1. 1 × UPDATE `jos_extensions` 
        SET `params` = '{\"mediaversion\":\"ecb035216db4b42add7137085bc40da5\"}'
    2. 1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
        VALUES ('782d17eef2779d16541d48cb1d3da7b1', 1, '1511048016', 0, '', 0