GRANDE ÉCOLE
D'INGÉNIEURS GÉNÉRALISTES

Console de débogage Joomla!

Session

Profil d'information

Occupation de la mémoire

Requêtes de base de données

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down

  FROM enib_modules AS m
  LEFT JOIN enib_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  LEFT JOIN enib_advancedmodules as am
  ON am.moduleid = m.id
  WHERE m.published = 1
  AND e.enabled = 1
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND m.language IN ('fr-FR','*')
  ORDER BY m.position, m.ordering
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmrefpublished,newsfeeds,idx_languagepublished1const54Using where; Utilisation du tri complet de type filesort
1SIMPLEameq_refPRIMARYPRIMARY4enib.m.id1
1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403enib.m.module,const1Using where
StatusDuration
starting0.09 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.02 ms
statistics0.09 ms
preparing0.02 ms
executing0.00 ms
Sorting result0.32 ms
Sending data0.75 ms
end0.01 ms
query end0.00 ms
closing tables0.01 ms
freeing items0.03 ms
logging slow query0.00 ms
cleaning up0.00 ms
#AppelFichier et numéro de ligne
20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
19JDatabaseDriver->loadObjectList()JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:404
18PlgSystemAdvancedModuleHelper->getModuleList()JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
17PlgSystemAdvancedModuleHelper->onPrepareModuleList()Même appel que celui de la ligne ci-dessous.
16call_user_func_array()JROOT/libraries/joomla/event/dispatcher.php:165
15JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
14JApplicationBase->triggerEvent()JROOT/libraries/cms/module/helper.php:355
13JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
12JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:576
11JDocumentHtml->countModules()JROOT/plugins/system/helix3/core/helix3.php:502
10Helix3::countModules()JROOT/plugins/system/helix3/core/helix3.php:458
9Helix3::rowColumns()JROOT/plugins/system/helix3/core/helix3.php:222
8Helix3::generatelayout()JROOT/templates/shaper_helix3/index.php:165
7require JROOT/templates/shaper_helix3/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

  • Temps de requête : 0.75 ms Après la dernière requête : 237.08 ms Mémoire de requête : 0.027 MB mémoire avant requête : 21.307 MB Rangées retournées : 2
    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 enib_categories as c
      LEFT JOIN enib_categories AS s
      ON (s.lft < c.lft
      AND s.rgt > c.rgt
      AND c.language in ('fr-FR','*')) 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=190
      ORDER BY c.lft
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1Utilisation du tri complet de type filesort
    1SIMPLEcALLcat_idx,idx_access,idx_left_right,idx_languageINDEX N'A PU ÊTRE UTILISÉNULLNULL103Using where
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.03 ms
    executing0.00 ms
    Sorting result0.13 ms
    Sending data0.06 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #AppelFichier et numéro de ligne
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    14JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:304
    13JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    12JCategories->get()JROOT/templates/shaper_helix3/html/mod_articles_category/temoignages.php:30
    11require JROOT/templates/shaper_helix3/html/mod_articles_category/temoignages.phpJROOT/modules/mod_articles_category/mod_articles_category.php:90
    10include JROOT/modules/mod_articles_category/mod_articles_category.phpJROOT/libraries/cms/module/helper.php:198
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:474
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:777
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:552
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1116
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->execute()JROOT/index.php:49

  • Temps de requête : 0.67 ms Après la dernière requête : 300.94 ms Mémoire de requête : 0.018 MB mémoire avant requête : 21.584 MB Rangées retournées : 6
    SELECT `name`,`element`
    
      FROM `enib_extensions`
      WHERE `type` = 'plugin'
      AND `folder` = 'finder'
      AND `enabled` = 1
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEenib_extensionsrefextensionextension82const92Using where
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.24 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
    #AppelFichier et numéro de ligne
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_finder/helpers/language.php:125
    11FinderHelperLanguage::loadPluginLanguage()JROOT/modules/mod_finder/mod_finder.php:51
    10include JROOT/modules/mod_finder/mod_finder.phpJROOT/libraries/cms/module/helper.php:198
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:474
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:777
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:552
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1116
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->execute()JROOT/index.php:49

  • Temps de requête : 0.33 ms Après la dernière requête : 11.56 ms Mémoire de requête : 0.021 MB mémoire avant requête : 21.920 MB Rangées retournées : 4
    SELECT `title`
    
      FROM `enib_finder_taxonomy`
      WHERE `parent_id` = 1
      AND `state` = 1
      AND `access` IN (1,1)
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEenib_finder_taxonomyrefparent_id,state,access,idx_parent_publishedparent_id4const4Using where
    StatusDuration
    starting0.03 ms
    checking permissions0.00 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.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #AppelFichier et numéro de ligne
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1530
    15JDatabaseDriver->loadColumn()JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
    14FinderIndexerTaxonomy::getBranchTitles()JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
    13FinderIndexerQuery->processString()JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
    12FinderIndexerQuery->__construct()JROOT/modules/mod_finder/helper.php:86
    11ModFinderHelper::getQuery()JROOT/modules/mod_finder/mod_finder.php:54
    10include JROOT/modules/mod_finder/mod_finder.phpJROOT/libraries/cms/module/helper.php:198
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:474
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:777
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:552
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1116
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->execute()JROOT/index.php:49

  • Temps de requête : 0.26 ms Après la dernière requête : 6.07 ms Mémoire de requête : 0.020 MB mémoire avant requête : 22.070 MB Rangées retournées : 0
    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `enib_menu` AS `c`
      INNER JOIN `enib_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_menus.item'
      INNER JOIN `enib_associations` AS `a2`
      ON a.key = a2.key
      INNER JOIN `enib_menu` AS `c2`
      ON a2.id = c2.`id`
      WHERE c.id = 978
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULLNULLImpossible WHERE noticed after reading const tables
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.00 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #AppelFichier et numéro de ligne
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    14JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/associations.php:101
    13JLanguageAssociations::getAssociations()JROOT/administrator/components/com_menus/helpers/menus.php:314
    12MenusHelper::getAssociations()JROOT/modules/mod_languages/helper.php:61
    11ModLanguagesHelper::getList()JROOT/modules/mod_languages/mod_languages.php:17
    10include JROOT/modules/mod_languages/mod_languages.phpJROOT/libraries/cms/module/helper.php:198
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:474
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:777
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:552
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1116
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->execute()JROOT/index.php:49

  • Temps de requête : 0.33 ms Après la dernière requête : 0.94 ms Mémoire de requête : 0.021 MB mémoire avant requête : 22.114 MB Rangées retournées : 0
    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
    
      FROM `enib_content` AS `c`
      INNER JOIN `enib_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_content.item'
      INNER JOIN `enib_associations` AS `a2`
      ON a.key = a2.key
      INNER JOIN `enib_content` AS `c2`
      ON a2.id = c2.`id`
      INNER JOIN `enib_categories` AS `ca`
      ON `c2`.`catid` = ca.id
      AND ca.extension = 'com_content'
      WHERE c.id = 551
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULLNULLImpossible WHERE noticed after reading const tables
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.00 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    #AppelFichier et numéro de ligne
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/associations.php:101
    14JLanguageAssociations::getAssociations()JROOT/components/com_content/helpers/association.php:43
    13ContentHelperAssociation::getAssociations()Même appel que celui de la ligne ci-dessous.
    12call_user_func()JROOT/modules/mod_languages/helper.php:70
    11ModLanguagesHelper::getList()JROOT/modules/mod_languages/mod_languages.php:17
    10include JROOT/modules/mod_languages/mod_languages.phpJROOT/libraries/cms/module/helper.php:198
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:474
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:777
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:552
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1116
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->execute()JROOT/index.php:49

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

    Tables sélectionnées :
    1. 2 × 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 enib_categories as c
        LEFT JOIN enib_categories AS s
        ON (s.lft < c.lft
        AND s.rgt > c.rgt
        AND c.language in ('fr-FR','*')) OR (s.lft >= c.lft
        AND s.rgt <= c.rgt)
    2. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down 
        FROM enib_modules AS m
        LEFT JOIN enib_extensions AS e
        ON e.element = m.module
        AND e.client_id = m.client_id
        LEFT JOIN enib_advancedmodules as am
        ON am.moduleid = m.id
    3. 1 × SELECT `m`.`tag_id`,`t`.* 
        FROM `enib_contentitem_tag_map` AS m
        INNER JOIN `enib_tags` AS t
        ON `m`.`tag_id` = `t`.`id`
    4. 1 × SELECT `name`,`element` 
        FROM `enib_extensions`
    5. 1 × SELECT `title` 
        FROM `enib_finder_taxonomy`
    6. 1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
        FROM `enib_content` AS `c`
        INNER JOIN `enib_associations` AS `a`
        ON a.id = c.`id`
        AND a.context='com_content.item'
        INNER JOIN `enib_associations` AS `a2`
        ON a.key = a2.key
        INNER JOIN `enib_content` AS `c2`
        ON a2.id = c2.`id`
        INNER JOIN `enib_categories` AS `ca`
        ON `c2`.`catid` = ca.id
        AND ca.extension = 'com_content'
    7. 1 × SELECT `c2`.`language`,`c2`.`id` 
        FROM `enib_menu` AS `c`
        INNER JOIN `enib_associations` AS `a`
        ON a.id = c.`id`
        AND a.context='com_menus.item'
        INNER JOIN `enib_associations` AS `a2`
        ON a.key = a2.key
        INNER JOIN `enib_menu` AS `c2`
        ON a2.id = c2.`id`
    8. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
        CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
        FROM enib_content AS a
        INNER JOIN enib_categories AS c
        on c.id = a.catid
        LEFT JOIN enib_users AS u
        on u.id = a.created_by
        LEFT JOIN enib_categories as parent
        ON parent.id = c.parent_id
        LEFT JOIN enib_content_rating AS v
        ON a.id = v.content_id
    9. 1 × SELECT * 
        FROM enib_content
    10. 1 × SELECT id, rules 
        FROM `enib_viewlevels
    11. 1 × SELECT `session_id` 
        FROM `enib_session`
    12. 1 × SELECT b.id 
        FROM enib_usergroups AS a
        LEFT JOIN enib_usergroups AS b
        ON b.lft <= a.lft
        AND b.rgt >= a.rgt
    13. 1 × SELECT a.*,u.name AS editor,e.enabled AS enabled 
        FROM `enib_externallogin_servers` as a
        LEFT JOIN enib_users AS u
        ON u.id=a.checked_out
        LEFT JOIN enib_extensions AS e
        ON `e`.`type`='plugin'
        AND CONCAT_WS('.', `e`.`folder`, `e`.`element`)=`a`.`plugin`
    14. 1 × SELECT params 
        FROM enib_extensions
    15. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
        FROM `enib_assets`
    16. 1 × SELECT `data` 
        FROM `enib_session`
    Autres tables :
    1. 1 × UPDATE enib_content 
        SET `hits` = (`hits` + 1)
    2. 1 × SHOW FULL COLUMNS 
        FROM `enib_content
    3. 1 × UPDATE `enib_extensions` 
        SET `params` = '{\"mediaversion\":\"68569e116dd4148f355b4e073d9818c0\"}'
    4. 1 × INSERT INTO `enib_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
        VALUES ('0f1l9chslt6tphdt88ql3crrj0', 1, '1505919071', 0, '', 0
    5. 1 × DELETE  
        FROM `enib_session`