Login OK en backend
-------------------
Requêtes de base de données
39 requêtes exécutées

    SELECT `data`
      FROM `jmgii_session`
      WHERE `session_id` = 'e0e8af3b733d0cd0647f97d9b0732ba0'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM jmgii_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM jmgii_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
    SELECT b.id
      FROM jmgii_user_usergroup_map AS map
      LEFT JOIN jmgii_usergroups AS a
      ON a.id = map.group_id
      LEFT JOIN jmgii_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE map.user_id = 63
    SELECT id, rules
      FROM `jmgii_viewlevels`
    SELECT folder AS type, element AS name, params
      FROM jmgii_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,2,3,5,7)
      ORDER BY ordering
    SELECT `value`
      FROM `jmgii_admintools_storage`
      WHERE `key` = 'cparams'
    SELECT `query`
      FROM `jmgii_admintools_wafexceptions`
      WHERE (`option` IS NULL OR `option` = '')
      AND (`view` IS NULL OR `view` = '')
      GROUP BY `query`
      ORDER BY `query` ASC
    SELECT `enabled`
      FROM `jmgii_extensions`
      WHERE `element` = 'com_akeeba'
      AND `type` = 'component'
    SELECT template, s.params
      FROM jmgii_template_styles as s
      LEFT JOIN jmgii_extensions as e
      ON e.type='template'
      AND e.element=s.template
      AND e.client_id=s.client_id
      WHERE s.client_id = 1
      AND home = '1'
      ORDER BY home
    SELECT *
      FROM `jmgii_admintools_ipautoban`
      WHERE `ip` = '86.218.13.188'
    SELECT `value`
      FROM `jmgii_admintools_storage`
      WHERE `key` = 'cparams'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM jmgii_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_cpanel'
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM jmgii_modules AS m
      LEFT JOIN jmgii_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jmgii_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 <= '2013-04-04 22:29:48')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-04-04 22:29:48')
      AND m.access IN (1,1,2,3,5,7)
      AND m.client_id = 1
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    SELECT s.time, s.client_id, u.id, u.name, u.username
      FROM jmgii_session AS s
      LEFT JOIN jmgii_users AS u
      ON s.userid = u.id
      WHERE s.guest = 0
      LIMIT 0, 5
    SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
      FROM jmgii_content AS a
      LEFT JOIN `jmgii_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jmgii_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jmgii_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jmgii_categories AS c
      ON c.id = a.catid
      LEFT JOIN jmgii_users AS ua
      ON ua.id = a.created_by
      ORDER BY a.hits DESC
    SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
      FROM jmgii_content AS a
      LEFT JOIN `jmgii_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jmgii_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jmgii_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jmgii_categories AS c
      ON c.id = a.catid
      LEFT JOIN jmgii_users AS ua
      ON ua.id = a.created_by
      ORDER BY a.hits DESC
      LIMIT 0, 5
    SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
      FROM jmgii_content AS a
      LEFT JOIN `jmgii_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jmgii_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jmgii_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jmgii_categories AS c
      ON c.id = a.catid
      LEFT JOIN jmgii_users AS ua
      ON ua.id = a.created_by
      ORDER BY created DESC
    SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
      FROM jmgii_content AS a
      LEFT JOIN `jmgii_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jmgii_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jmgii_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jmgii_categories AS c
      ON c.id = a.catid
      LEFT JOIN jmgii_users AS ua
      ON ua.id = a.created_by
      ORDER BY created DESC
      LIMIT 0, 5
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM jmgii_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_jce'
    UPDATE `jmgii_extensions`
      SET `enabled` = '0'
      WHERE `element` = 'akeebabackup'
      AND `folder` = 'quickicon'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM jmgii_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_akeeba'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM jmgii_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_admintools'
    SELECT *
      FROM jmgii_wf_profiles
      WHERE published = 1
      ORDER BY ordering ASC
    SELECT *
      FROM jmgii_wf_profiles
      WHERE published = 1
      ORDER BY ordering ASC
    SHOW FULL COLUMNS
      FROM `jmgii_extensions`
    SELECT `extension_id`
      FROM `jmgii_extensions`
      WHERE type = 'component'
      AND element = 'com_jce'
    SELECT *
      FROM jmgii_extensions
      WHERE `extension_id` = '10033'
    UPDATE `jmgii_extensions`
      SET `enabled` = '1'
      WHERE `element` = 'akeebabackup'
      AND `folder` = 'quickicon'
    SELECT `value`
      FROM `jmgii_admintools_storage`
      WHERE `key` = 'cparams'
    SELECT COUNT(*)
      FROM jmgii_messages
      WHERE state = 0
      AND user_id_to = 63
    SELECT COUNT(session_id)
      FROM jmgii_session
      WHERE guest = 0
      AND client_id = 1
    SELECT COUNT(session_id)
      FROM jmgii_session
      WHERE guest = 0
      AND client_id = 0
    SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
      FROM jmgii_menu_types AS a
      LEFT JOIN jmgii_menu AS b
      ON b.menutype = a.menutype
      AND b.home != 0
      LEFT JOIN jmgii_languages AS l
      ON l.lang_code = language
      WHERE (b.client_id = 0 OR b.client_id IS NULL)
      GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
    SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
      FROM jmgii_menu AS m
      LEFT JOIN jmgii_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.client_id = 1
      AND e.enabled = 1
      AND m.id > 1
      ORDER BY m.lft
    SELECT `enabled`
      FROM `jmgii_extensions`
      WHERE `element` = 'com_akeeba'
      AND `type` = 'component'
    SELECT `enabled`
      FROM `jmgii_extensions`
      WHERE `element` = 'com_admintools'
      AND `type` = 'component'
    SELECT `params`
      FROM `jmgii_extensions`
      WHERE `element` = 'com_admintools'
      AND `type` = 'component'
    UPDATE `jmgii_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1365114494;s:18:\"session.timer.last\";i:1365114588;s:17:\"session.timer.now\";i:1365114588;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:2:\"63\";s:4:\"name\";s:16:\"Jean-Marie GROUD\";s:8:\"username\";s:7:\"jmgroud\";s:5:\"email\";s:23:\"jeanmarie.groud@free.fr\";s:8:\"password\";s:32:\"38fc554ebdb085be03b963c2bd651fc8\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2010-06-20 23:25:45\";s:13:\"lastvisitDate\";s:19:\"2013-04-04 22:28:14\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\",\"admin_style\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:11:\"admin_style\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:6:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:5;i:5;i:7;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f9f5b2eedce0179bcf65cca9b9279092\";}__wf|a:1:{s:13:\"session.token\";s:32:\"aa06718d4b1854bfb9e2084699c8c37c\";}' , `time` = '1365114588'
      WHERE `session_id` = 'e0e8af3b733d0cd0647f97d9b0732ba0'

26 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :

    6 × SELECT extension_id AS id, element AS "option", params, enabled
      FROM jmgii_extensions
    3 × SELECT `value`
      FROM `jmgii_admintools_storage`
    3 × SELECT `enabled`
      FROM `jmgii_extensions`
    2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
      FROM jmgii_content AS a
      LEFT JOIN `jmgii_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jmgii_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jmgii_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jmgii_categories AS c
      ON c.id = a.catid
      LEFT JOIN jmgii_users AS ua
      ON ua.id = a.created_by
    2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
      FROM jmgii_content AS a
      LEFT JOIN `jmgii_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jmgii_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jmgii_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jmgii_categories AS c
      ON c.id = a.catid
      LEFT JOIN jmgii_users AS ua
      ON ua.id = a.created_by
    2 × SELECT *
      FROM jmgii_wf_profiles
    2 × SELECT COUNT(session_id)
      FROM jmgii_session
    1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
      FROM jmgii_menu AS m
      LEFT JOIN jmgii_extensions AS e
      ON m.component_id = e.extension_id
    1 × SELECT `params`
      FROM `jmgii_extensions`
    1 × SELECT `extension_id`
      FROM `jmgii_extensions`
    1 × SELECT *
      FROM jmgii_extensions
    1 × SELECT COUNT(*)
      FROM jmgii_messages
    1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
      FROM jmgii_menu_types AS a
      LEFT JOIN jmgii_menu AS b
      ON b.menutype = a.menutype
      AND b.home != 0
      LEFT JOIN jmgii_languages AS l
      ON l.lang_code = language
    1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM jmgii_modules AS m
      LEFT JOIN jmgii_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jmgii_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
    1 × SELECT folder AS type, element AS name, params
      FROM jmgii_extensions
    1 × SELECT id, rules
      FROM `jmgii_viewlevels
    1 × SELECT b.id
      FROM jmgii_user_usergroup_map AS map
      LEFT JOIN jmgii_usergroups AS a
      ON a.id = map.group_id
      LEFT JOIN jmgii_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
    1 × SELECT `query`
      FROM `jmgii_admintools_wafexceptions`
    1 × SELECT template, s.params
      FROM jmgii_template_styles as s
      LEFT JOIN jmgii_extensions as e
      ON e.type='template'
      AND e.element=s.template
      AND e.client_id=s.client_id
    1 × SELECT `data`
      FROM `jmgii_session`
    1 × SELECT *
      FROM `jmgii_admintools_ipautoban`
    1 × SELECT s.time, s.client_id, u.id, u.name, u.username
      FROM jmgii_session AS s
      LEFT JOIN jmgii_users AS u
      ON s.userid = u.id

Autres tables :

    1 × UPDATE `jmgii_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1365114494;s:18:\"session.timer.last\";i:1365114588;s:17:\"session.timer.now\";i:1365114588;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:2:\"63\";s:4:\"name\";s:16:\"Jean-Marie GROUD\";s:8:\"username\";s:7:\"jmgroud\";s:5:\"email\";s:23:\"jeanmarie.groud@free.fr\";s:8:\"password\";s:32:\"38fc554ebdb085be03b963c2bd651fc8\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2010-06-20 23:25:45\";s:13:\"lastvisitDate\";s:19:\"2013-04-04 22:28:14\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\",\"admin_style\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:11:\"admin_style\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:6:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:5;i:5;i:7;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f9f5b2eedce0179bcf65cca9b9279092\";}__wf|a:1:{s:13:\"session.token\";s:32:\"aa06718d4b1854bfb9e2084699c8c37c\";}' , `time` = '1365114588'
    1 × UPDATE `jmgii_extensions`
      SET `enabled` = '1'
    1 × SHOW FULL COLUMNS
      FROM `jmgii_extensions
    1 × UPDATE `jmgii_extensions`
      SET `enabled` = '0'