Recherche

ES - INSA

Excellence Sportive

Vue du menu de recherche

Menu

Console de débogage Joomla!

Session

Profil d'information

Occupation de la mémoire

Requêtes de base de données

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.featured = 1
  AND a.access IN (1,1)
  AND c.access IN (1,1)
  AND c.published = 1
  AND a.state = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-23 14:23:12')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-23 14:23:12')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEarefidx_access,idx_state,idx_catid,idx_featured_catididx_featured_catid1const11Using where
1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4exlsport_jos1.a.catid1Using where
1SIMPLEuaeq_refPRIMARYPRIMARY4exlsport_jos1.a.created_by1Using index
1SIMPLEuameq_refPRIMARYPRIMARY4exlsport_jos1.a.modified_by1Using index
1SIMPLEparenteq_refPRIMARYPRIMARY4exlsport_jos1.c.parent_id1Using index
1SIMPLEveq_refPRIMARYPRIMARY4exlsport_jos1.a.id1Using index
StatusDuration
starting0.12 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.06 ms
optimizing0.03 ms
statistics0.10 ms
preparing0.04 ms
executing0.01 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.00 ms
#CallerFile and line number
16JDatabaseDriverMysql->execute()JROOT/libraries/joomla/database/driver.php:1720
15JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:334
14JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:281
13JModelList->getTotal()JROOT/libraries/legacy/model/list.php:231
12JModelList->getPagination()JROOT/libraries/legacy/view/legacy.php:422
11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:56
10ContentViewFeatured->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 : 13.37 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=2
      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.16 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.07 ms
    optimizing0.03 ms
    statistics0.23 ms
    preparing0.04 ms
    executing0.00 ms
    Sorting result0.10 ms
    Sending data0.11 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/featured/view.html.php:98
    10ContentViewFeatured->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.81 ms Après la dernière requête : 0.67 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.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (2,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.16 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.07 ms
    System lock0.01 ms
    init0.09 ms
    optimizing0.03 ms
    statistics0.10 ms
    preparing0.05 ms
    executing0.00 ms
    Sorting result0.04 ms
    Sending data0.05 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
    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/featured/view.html.php:98
    10ContentViewFeatured->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.75 ms Après la dernière requête : 10.65 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.14 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.06 ms
    optimizing0.06 ms
    statistics0.11 ms
    preparing0.03 ms
    executing0.00 ms
    Sorting result0.07 ms
    Sending data0.09 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/featured/view.html.php:98
    10ContentViewFeatured->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.69 ms Après la dernière requête : 0.60 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.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.16 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.04 ms
    System lock0.01 ms
    init0.08 ms
    optimizing0.03 ms
    statistics0.08 ms
    preparing0.05 ms
    executing0.00 ms
    Sorting result0.03 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.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/featured/view.html.php:98
    10ContentViewFeatured->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.07 ms Après la dernière requête : 52.65 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:23:12')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-23 14:23:12')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 102 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.00 ms
    Opening tables0.06 ms
    System lock0.01 ms
    init0.07 ms
    optimizing0.03 ms
    statistics0.08 ms
    preparing0.05 ms
    executing0.00 ms
    Sorting result0.15 ms
    Sending data0.32 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
    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

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

    Tables sélectionnées :
    1. 9 × 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 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)
    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 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 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
    8. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
        FROM `jos_assets`
    9. 1 × SELECT * 
        FROM jos_languages
    10. 1 × SELECT id, rules 
        FROM `jos_viewlevels
    11. 1 × SELECT `session_id` 
        FROM `jos_session`
    12. 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
    13. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
        FROM jos_extensions
    14. 1 × SELECT `data` 
        FROM `jos_session`
    15. 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
    16. 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
    Autres tables :
    1. 1 × UPDATE `jos_extensions` 
        SET `params` = '{\"mediaversion\":\"5851279ea9852081efb1515d538ce605\"}'
    2. 1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
        VALUES ('de8f07677cd7a482f6878b3e846fd6db', 1, '1506176592', 0, '', 0