Recherche

ES - INSA

Excellence Sportive

Vue du menu de recherche

Menu

.:. Jérémy Roy .:. 1ere sélection en équipe de France en savoir +
Ch monde CLM Valkenburg 2012 PDF Imprimer Envoyer
Mercredi, 19 Septembre 2012 20:58

46kms sur un parcours exigeant avec un vent majoritairement défavorable.

Malheureusement, peu de temps avant mon départ une averse est venue rendre mon périple assez glissant !! Un peu de temps perdu car les premiers et les derniers ont eu un parcours plus sec.

Mais je me suis livré au combat comme d'habitude , terminant à une honnête 18ème place , assez loin de Martin et Phinney mais à seulement 30" du top 10.

De quoi motiver pour continuer à travailler la spécialité.

Merci à Françoise d'avoir fait le déplacement pour m'encourager et nous offrir ces belles photos

 

 

Jean François Cuzon gagne une étape du tour de l'Europe en Mod 70

Article de leur arrivée à Marseille

Leg 4 Cascais to Marseille
1. Musandam Oman Sail finish time: 07h 11m 34s (3 days 16 hours 11 minutes and 34 seconds)
2. Race for Water – 2h 23m 7s after winner
3. FONCIA – 2h 45m 32s after winner

Un profil pas si atypique que ça : http://www.vendeeglobe.org

 

Articles | jeudi 11 octobre 2012, 18h01

 

Prenez six éditions du Vendée Globe, analysez les six vainqueurs, ajoutez-y quelques chiffres, divisez le tout par 6 et vous obtiendrez le profil du vainqueur de l’édition 2012-2013. Mais cela ne reste que des chiffres… quoique !

Armel Le Cléach 2012 - 15

Selon les mathématiques, le vainqueur 2013 sera un homme français d’environ 34 ans et demi, originaire de Bretagne avec les yeux foncés. C’est à bord d’un IMOCA blanc qu’il remportera la course et son palmarès aura auparavant été rempli par une victoire dans la Solitaire du Figaro, dans une transatlantique ou dans un tour du monde.

Ce vainqueur « mathématique» n’est pas si virtuel que cela car un marin se rapproche étrangement de ce profil. Après analyse du plateau de cette 7e édition, le vainqueur 2012 serait donc… Armel Le Cleac’h sur Banque Populaire. Ce Breton, né à Saint-Pol-de-Léon dans le Finistère, a 35 ans et a remporté deux Solitaire du Figaro (2003 et 2010). Déjà de grandes similitudes avec le portrait-robot. Mais il lui faut un bateau blanc et, qu’à cela ne tienne, Banque Populaire est assez blanc pour entrer dans les statistiques.

Sur le papier Armel est donc le vainqueur 2013 du Vendée Globe, mais pour bien faire (après une nouvelle étude poussée des chiffres passés), il lui faudrait théoriquement parcourir 26 505 milles en 4 jours de moins que le record de Michel Desjoyeaux (84 jours et 3 heures). Il devrait aussi disposer de 3 jours et 8 heures d’avance sur son dauphin et l’écart avec le dernier serait de 46 jours.

Rendez vous donc aux alentours du 19 janvier pour découvrir si le monocoque blanc et bleu d’Armel Le Cleac’h entrera en grand vainqueur dans le chenal des Sables d’Olonne.

 

Console de débogage Joomla!

Session

Profil d'information

Occupation de la mémoire

Requêtes de base de données

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jos_assets`
  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_club','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_issuetracker','com_joomlaupdate','com_languages','com_login','com_mailsportif','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sport','com_sportif','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEjos_assetsALLidx_asset_nameINDEX N'A PU ÊTRE UTILISÉNULLNULL96Using where
StatusDuration
starting0.09 ms
checking permissions0.04 ms
Opening tables0.02 ms
System lock0.01 ms
init0.09 ms
optimizing0.01 ms
statistics0.22 ms
preparing0.01 ms
executing0.00 ms
Sending data0.35 ms
end0.01 ms
query end0.00 ms
closing tables0.01 ms
freeing items0.02 ms
logging slow query0.00 ms
cleaning up0.00 ms
#CallerFile and line number
20JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
19JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/access/access.php:427
18JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:211
17JAccess::preload()JROOT/libraries/joomla/access/access.php:529
16JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
15JAccess::check()JROOT/libraries/joomla/user/user.php:393
14JUser->authorise()JROOT/components/com_content/models/category.php:142
13ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:434
12JModelLegacy->getState()JROOT/libraries/legacy/view/category.php:115
11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
6require_once JROOT/components/com_content/content.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.65 ms Après la dernière requête : 0.81 ms
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjos_assetsALLidx_asset_name,idx_parent_idINDEX N'A PU ÊTRE UTILISÉNULLNULL96Using where
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.28 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    20JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    19JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/access/access.php:357
    18JAccess::preloadPermissions()JROOT/libraries/joomla/access/access.php:224
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:538
    16JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    15JAccess::check()JROOT/libraries/joomla/user/user.php:393
    14JUser->authorise()JROOT/components/com_content/models/category.php:142
    13ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:434
    12JModelLegacy->getState()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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 : 2.03 ms Après la dernière requête : 5.05 ms
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
      FROM jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN `jos_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.published = 1
      AND s.id=14
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1Using temporary; Utilisation du tri complet de type filesort
    1SIMPLEcALLcat_idx,idx_left_rightINDEX N'A PU ÊTRE UTILISÉNULLNULL20Using where
    1SIMPLEirefidx_state,idx_catididx_catid4exlsport_jos1.c.id1
    StatusDuration
    starting0.20 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.13 ms
    optimizing0.03 ms
    statistics0.15 ms
    preparing0.09 ms
    Creating tmp table0.58 ms
    executing0.01 ms
    Copying to tmp table0.43 ms
    Sorting result0.03 ms
    Sending data0.06 ms
    end0.00 ms
    removing tmp table0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    17JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    16JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:304
    15JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    14JCategories->get()JROOT/components/com_content/models/category.php:355
    13ContentModelCategory->getCategory()JROOT/libraries/legacy/view/legacy.php:422
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:121
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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 : 1.94 ms Après la dernière requête : 4.68 ms
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM jos_content AS a
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.catid = 14
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-23 14:26:20')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-23 14:26:20')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END , a.created
      LIMIT 9
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1Utilisation du tri complet de type filesort
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const4Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4exlsport_jos1.a.created_by1
    1SIMPLEuameq_refPRIMARYPRIMARY4exlsport_jos1.a.modified_by1
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1
    1SIMPLEveq_refPRIMARYPRIMARY4exlsport_jos1.a.id1
    StatusDuration
    starting0.27 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.01 ms
    init0.14 ms
    optimizing0.04 ms
    statistics0.13 ms
    preparing0.06 ms
    executing0.00 ms
    Sorting result0.08 ms
    Sending data0.78 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    #CallerFile and line number
    18JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    17JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    16JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:186
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:536
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.55 ms Après la dernière requête : 4.50 ms
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 13
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeINDEX N'A PU ÊTRE UTILISÉNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4exlsport_jos1.m.tag_id1Using where
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.05 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    17JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.50 ms Après la dernière requête : 0.91 ms
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 27
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeINDEX N'A PU ÊTRE UTILISÉNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4exlsport_jos1.m.tag_id1Using where
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.05 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    17JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.46 ms Après la dernière requête : 0.93 ms
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 29
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeINDEX N'A PU ÊTRE UTILISÉNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4exlsport_jos1.m.tag_id1Using where
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.05 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    17JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.50 ms Après la dernière requête : 0.90 ms
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 30
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeINDEX N'A PU ÊTRE UTILISÉNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4exlsport_jos1.m.tag_id1Using where
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.05 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    17JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.76 ms Après la dernière requête : 2.61 ms
    SELECT COUNT(*)
    
      FROM jos_content AS a
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.catid = 14
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-23 14:26:20')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-23 14:26:20')
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const4Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4exlsport_jos1.a.created_by1Using index
    1SIMPLEuameq_refPRIMARYPRIMARY4exlsport_jos1.a.modified_by1Using index
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using index
    1SIMPLEveq_refPRIMARYPRIMARY4exlsport_jos1.a.id1Using index
    StatusDuration
    starting0.15 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.12 ms
    preparing0.05 ms
    executing0.01 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    18JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1720
    17JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:334
    16JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:281
    15JModelList->getTotal()JROOT/libraries/legacy/model/list.php:231
    14JModelList->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.47 ms Après la dernière requête : 0.77 ms
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m
      INNER JOIN `jos_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 14
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeINDEX N'A PU ÊTRE UTILISÉNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4exlsport_jos1.m.tag_id1Using where
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.05 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 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/libraries/cms/helper/tags.php:450
    12JHelperTags->getItemTags()JROOT/libraries/legacy/view/category.php:225
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.82 ms Après la dernière requête : 11.10 ms
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=14
      ORDER BY c.lft
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1Utilisation du tri complet de type filesort
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightINDEX N'A PU ÊTRE UTILISÉNULLNULL20Using where
    StatusDuration
    starting0.17 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.12 ms
    preparing0.03 ms
    executing0.00 ms
    Sorting result0.09 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #CallerFile and line number
    22JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    21JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:304
    20JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    19JCategories->get()JROOT/administrator/components/com_fields/models/fields.php:197
    18FieldsModelFields->getListQuery()JROOT/libraries/legacy/model/list.php:132
    17JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:186
    16JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    15FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    14PlgSystemFields->onContentPrepare()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:108
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.83 ms Après la dernière requête : 0.69 ms
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM jos_fields AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOINjos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (14,0))
      AND a.access IN (1,1)
      AND (a.group_id = 0 OR g.access IN (1,1))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Utilisation du tri complet de type filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28exlsport_jos1.a.language1
    1SIMPLEuceq_refPRIMARYPRIMARY4exlsport_jos1.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4exlsport_jos1.a.access1
    1SIMPLEuaeq_refPRIMARYPRIMARY4exlsport_jos1.a.created_user_id1
    1SIMPLEgeq_refPRIMARYPRIMARY4exlsport_jos1.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4exlsport_jos1.a.id1Using where; Using index
    StatusDuration
    starting0.17 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.05 ms
    System lock0.01 ms
    init0.08 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.11 ms
    executing0.00 ms
    Sorting result0.04 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    #CallerFile and line number
    20JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    19JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    18JModelLegacy->_getList()JROOT/administrator/components/com_fields/models/fields.php:326
    17FieldsModelFields->_getList()JROOT/libraries/legacy/model/list.php:186
    16JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    15FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    14PlgSystemFields->onContentPrepare()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:108
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.78 ms Après la dernière requête : 23.89 ms
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM jos_fields AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.categories'
      AND (fc.category_id IS NULL OR fc.category_id IN (14,0))
      AND a.access IN (1,1)
      AND (a.group_id = 0 OR g.access IN (1,1))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Utilisation du tri complet de type filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28exlsport_jos1.a.language1
    1SIMPLEuceq_refPRIMARYPRIMARY4exlsport_jos1.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4exlsport_jos1.a.access1
    1SIMPLEuaeq_refPRIMARYPRIMARY4exlsport_jos1.a.created_user_id1
    1SIMPLEgeq_refPRIMARYPRIMARY4exlsport_jos1.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4exlsport_jos1.a.id1Using where; Using index
    StatusDuration
    starting0.17 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.01 ms
    init0.08 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.05 ms
    executing0.00 ms
    Sorting result0.04 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    #CallerFile and line number
    24JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1681
    23JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    22JModelLegacy->_getList()JROOT/administrator/components/com_fields/models/fields.php:326
    21FieldsModelFields->_getList()JROOT/libraries/legacy/model/list.php:186
    20JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    18PlgSystemFields->onContentPrepare()Same as call in the line below.
    17call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    16JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    15JEventDispatcher->trigger()JROOT/components/com_content/views/category/tmpl/blog.php:19
    14include JROOT/components/com_content/views/category/tmpl/blog.phpJROOT/libraries/legacy/view/legacy.php:694
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    12JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    11JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:671
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.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.93 ms Après la dernière requête : 38.00 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-09-23 14:26:20')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-23 14:26:20')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 108 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.13 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.06 ms
    optimizing0.03 ms
    statistics0.08 ms
    preparing0.05 ms
    executing0.00 ms
    Sorting result0.13 ms
    Sending data0.20 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.01 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

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

    Tables sélectionnées :
    1. 5 × SELECT `m`.`tag_id`,`t`.* 
        FROM `jos_contentitem_tag_map` AS m
        INNER JOIN `jos_tags` AS t
        ON `m`.`tag_id` = `t`.`id`
    2. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
        FROM `jos_assets`
    3. 2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
        FROM jos_fields AS a
        LEFT JOIN `jos_languages` AS l
        ON l.lang_code = a.language
        LEFT JOIN jos_users AS uc
        ON uc.id=a.checked_out
        LEFT JOIN jos_viewlevels AS ag
        ON ag.id = a.access
        LEFT JOIN jos_users AS ua
        ON ua.id = a.created_user_id
        LEFT JOIN jos_fields_groups AS g
        ON g.id = a.group_id
        LEFT JOIN `jos_fields_categories` AS fc
        ON fc.field_id = a.id
    4. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
        FROM `jos_extensions`
    5. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
        CASE WHEN c.published = 2
        AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
        CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
        CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
        CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
        FROM jos_content AS a
        LEFT JOIN jos_categories AS c
        ON c.id = a.catid
        LEFT JOIN jos_users AS ua
        ON ua.id = a.created_by
        LEFT JOIN jos_users AS uam
        ON uam.id = a.modified_by
        LEFT JOIN jos_categories as parent
        ON parent.id = c.parent_id
        LEFT JOIN jos_content_rating AS v
        ON a.id = v.content_id
    6. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
        CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
        FROM jos_categories as c
        LEFT JOIN jos_categories AS s
        ON (s.lft <= c.lft
        AND s.rgt >= c.rgt) OR (s.lft > c.lft
        AND s.rgt < c.rgt)
        LEFT JOIN `jos_content` AS i
        ON i.`catid` = c.id
        AND i.state = 1
    7. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
        CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
        FROM jos_categories as c
        LEFT JOIN jos_categories AS s
        ON (s.lft <= c.lft
        AND s.rgt >= c.rgt) OR (s.lft > c.lft
        AND s.rgt < c.rgt)
    8. 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
    9. 1 × SELECT COUNT(*) 
        FROM jos_content AS a
        LEFT JOIN jos_categories AS c
        ON c.id = a.catid
        LEFT JOIN jos_users AS ua
        ON ua.id = a.created_by
        LEFT JOIN jos_users AS uam
        ON uam.id = a.modified_by
        LEFT JOIN jos_categories as parent
        ON parent.id = c.parent_id
        LEFT JOIN jos_content_rating AS v
        ON a.id = v.content_id
    10. 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
    11. 1 × SELECT id, rules 
        FROM `jos_viewlevels
    12. 1 × SELECT `session_id` 
        FROM `jos_session`
    13. 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
    14. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
        FROM jos_extensions
    15. 1 × SELECT * 
        FROM jos_languages
    16. 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
    17. 1 × SELECT `data` 
        FROM `jos_session`
    Autres tables :
    1. 1 × UPDATE `jos_extensions` 
        SET `params` = '{\"mediaversion\":\"d6d27f2b372c407f0db069f351b3025f\"}'
    2. 1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
        VALUES ('d0ee40742919e783c2d2488ebb5e79a7', 1, '1506176780', 0, '', 0