39 requêtes exécutées

    SELECT `data`
      FROM `JOOM_session`
      WHERE `session_id` = 'sm1fpajpodtrdo3h06elpt2872'
    SELECT folder AS type, element AS name, params
      FROM JOOM_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,2,3)
      ORDER BY ordering
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM JOOM_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    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 JOOM_menu AS m
      LEFT JOIN JOOM_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    INSERT INTO `JOOM_rokuserstats` (`user_id`,`ip`,`session_id`,`page`,`referrer`)
      VALUES ('104','109.128.40.184','sm1fpajpodtrdo3h06elpt2872','/mon-profile','http://www.teso-mmo.fr/mon-profile/userdetails')
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM JOOM_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_comprofiler'
    SELECT *
      FROM JOOM_languages
      WHERE published=1
      ORDER BY ordering ASC
    SELECT id, home, template, s.params
      FROM JOOM_template_styles as s
      LEFT JOIN JOOM_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    SHOW FULL COLUMNS
      FROM `JOOM_users`
    SELECT c.*, u.*
      FROM JOOM_users AS u
      LEFT JOIN JOOM_comprofiler AS c
      ON c.id = u.id
      WHERE u.id = 104
    SELECT a.id
      FROM JOOM_user_usergroup_map AS map
      LEFT JOIN JOOM_usergroups AS a
      ON a.id = map.group_id
      WHERE map.user_id = 104
    SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
      FROM JOOM_comprofiler_plugin
      WHERE published = 1
      AND access IN (0,1,2)
      AND type = 'user'
      ORDER BY ordering
    SELECT *
      FROM `JOOM_comprofiler_plugin`
      WHERE `element` = 'cbautoactions'
    SELECT *
      FROM `JOOM_comprofiler_plugin_autoactions`
      WHERE ( `published` = 1 )
      ORDER BY `ordering` ASC
    SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
      FROM JOOM_comprofiler_plugin
      WHERE published = 1
      AND access IN (0,1,2)
      AND type = 'templates'
      ORDER BY ordering
    SELECT *
      FROM `JOOM_usergroups`
      ORDER BY `lft`
    SELECT parent.id, parent.lft, parent.rgt
      FROM JOOM_usergroups AS parent
      ORDER BY parent.lft
    SHOW FULL COLUMNS
      FROM `JOOM_assets`
    SELECT id
      FROM JOOM_assets
      WHERE parent_id = 0
    SELECT b.rules
      FROM JOOM_assets AS a
      LEFT JOIN JOOM_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = '' OR a.parent_id=0)
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
    SELECT *
      FROM `JOOM_usergroups`
      ORDER BY `lft`
    SELECT b.id
      FROM JOOM_user_usergroup_map AS map
      LEFT JOIN JOOM_usergroups AS a
      ON a.id = map.group_id
      LEFT JOIN JOOM_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE map.user_id = 104
    SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level
      FROM `JOOM_usergroups` AS a
      LEFT JOIN `JOOM_usergroups` AS b
      ON a.`lft` > b.`lft`
      AND a.`rgt` < b.`rgt`
      GROUP BY a.`id`
      ORDER BY a.`lft` ASC
    SELECT *
      FROM JOOM_comprofiler_tabs t
      WHERE t.enabled=1
      AND t.viewaccesslevel IN (1,2,3)
      AND t.useraccessgroupid IN (-2,-1,1,6,7,2,3,4,5,8)
      ORDER BY t.position, t.ordering
    SELECT id
      FROM JOOM_menu
      WHERE link = 'index.php?option=com_comprofiler'
      AND published = 1
      AND access IN (1,2,3)
      AND `language` IN ( 'fr-FR', '*', '' )
    SELECT f.*
      FROM JOOM_comprofiler_fields f
      INNER JOIN JOOM_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
      WHERE f.published = 1
      AND f.profile != 0
      AND t.enabled = 1
      AND t.viewaccesslevel IN (1,2,3)
      AND t.useraccessgroupid IN (-2,-1,1,6,7,2,3,4,5,8)
      ORDER BY t.position, t.ordering, f.ordering
    SELECT MAX(time)
      FROM JOOM_session
      WHERE userid = 104
      AND guest = 0
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM JOOM_modules AS m
      LEFT JOIN JOOM_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN JOOM_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-05-03 21:31:08')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-05-03 21:31:08')
      AND m.access IN (1,1,2,3)
      AND m.client_id = 0
      AND (mm.menuid = 1383 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    SHOW FULL COLUMNS
      FROM `JOOM_komento_configs`
    SELECT *
      FROM JOOM_komento_configs
      WHERE `component` = 'com_komento'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM JOOM_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_seoglossary'
    SELECT t.*
      FROM JOOM_seoglossary t
      LEFT JOIN JOOM_seoglossaries g
      ON t.catid = g.id
      WHERE t.state = 1
      AND g.state = 1
      AND LOWER('&nbsp;&nbsp;&nbsp;&nbsp;') LIKE CONCAT('%', LOWER(t.tterm), '%')
      ORDER BY ordering;
    SELECT t.*
      FROM JOOM_seoglossary t
      LEFT JOIN JOOM_seoglossaries g
      ON t.catid = g.id
      WHERE t.state = 1
      AND g.state = 1
      AND LOWER('Les marques déposées sont la propriété de leurs propriétaires respectifs. Tous droits réservés ©2013 ZeniMax Media Inc. &amp; Bethesda / Les images et conceptions réalisée par Teso-mmo.fr sont libre de droits sous licence Creative Commons. ®\r\n&nbsp;') LIKE CONCAT('%', LOWER(t.tterm), '%')
      ORDER BY ordering;
    SELECT *
      FROM JOOM_modules
      WHERE published=1
      ORDER BY id ;
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM JOOM_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
    SELECT id, link
      FROM JOOM_menu
      WHERE link LIKE 'index.php?option=com_kide%'
      AND published='1'
    SELECT t.*
      FROM JOOM_seoglossary t
      LEFT JOIN JOOM_seoglossaries g
      ON t.catid = g.id
      WHERE t.state = 1
      AND g.state = 1
      AND LOWER('&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; \r\n&nbsp;') LIKE CONCAT('%', LOWER(t.tterm), '%')
      ORDER BY ordering;
    SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM JOOM_categories as c
      LEFT JOIN JOOM_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 (SELECT cat.id as id
      FROM JOOM_categories AS cat JOIN JOOM_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,2,3)
      AND c.published = 1
      AND s.id=2
      AND badcats.id is null
      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
      ORDER BY c.lft
    UPDATE `JOOM_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:25;s:19:\"session.timer.start\";i:1367615847;s:18:\"session.timer.last\";i:1367616665;s:17:\"session.timer.now\";i:1367616668;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";s:3:\"104\";s:4:\"name\";s:5:\"Gorgo\";s:8:\"username\";s:5:\"Gorgo\";s:5:\"email\";s:15:\"olivier@sohy.be\";s:8:\"password\";s:65:\"d6a81cdc8a3225d8d31f056c131ee498:YG9uut0CtBRbedkJrdooCCXi8m1JybhC\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-14 10:31:13\";s:13:\"lastvisitDate\";s:19:\"2013-05-03 21:17:32\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:108:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"Europe\\/Brussels\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";N;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";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:15:\"Europe/Brussels\";}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}}s:13:\"session.token\";s:32:\"da98be3d4a493a80ae0d6a80766c46b5\";}RESET_PHPBB_CACHE|i:1;' , `time` = '1367616668'
      WHERE `session_id` = 'sm1fpajpodtrdo3h06elpt2872'

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

    4 × SELECT extension_id AS id, element AS "option", params, enabled
      FROM JOOM_extensions
    3 × SELECT t.*
      FROM JOOM_seoglossary t
      LEFT JOIN JOOM_seoglossaries g
      ON t.catid = g.id
    2 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
      FROM JOOM_comprofiler_plugin
    2 × SELECT *
      FROM `JOOM_usergroups`
    1 × SELECT f.*
      FROM JOOM_comprofiler_fields f
      INNER JOIN JOOM_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
    1 × SELECT id
      FROM JOOM_menu
    1 × SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level
      FROM `JOOM_usergroups` AS a
      LEFT JOIN `JOOM_usergroups` AS b
      ON a.`lft` > b.`lft`
      AND a.`rgt` < b.`rgt`
      GROUP BY a.`id`
    1 × SELECT *
      FROM JOOM_comprofiler_tabs t
    1 × SELECT MAX(time)
      FROM JOOM_session
    1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM JOOM_modules AS m
      LEFT JOIN JOOM_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN JOOM_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
    1 × SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM JOOM_categories as c
      LEFT JOIN JOOM_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 (SELECT cat.id as id
      FROM JOOM_categories AS cat JOIN JOOM_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
    1 × SELECT id, link
      FROM JOOM_menu
    1 × SELECT *
      FROM JOOM_modules
    1 × SELECT *
      FROM JOOM_komento_configs
    1 × SELECT b.id
      FROM JOOM_user_usergroup_map AS map
      LEFT JOIN JOOM_usergroups AS a
      ON a.id = map.group_id
      LEFT JOIN JOOM_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
    1 × SELECT id
      FROM JOOM_assets
    1 × SELECT id, home, template, s.params
      FROM JOOM_template_styles as s
      LEFT JOIN JOOM_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
    1 × SELECT *
      FROM JOOM_languages
    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 JOOM_menu AS m
      LEFT JOIN JOOM_extensions AS e
      ON m.component_id = e.extension_id
    1 × SELECT folder AS type, element AS name, params
      FROM JOOM_extensions
    1 × SELECT c.*, u.*
      FROM JOOM_users AS u
      LEFT JOIN JOOM_comprofiler AS c
      ON c.id = u.id
    1 × SELECT a.id
      FROM JOOM_user_usergroup_map AS map
      LEFT JOIN JOOM_usergroups AS a
      ON a.id = map.group_id
    1 × SELECT `data`
      FROM `JOOM_session`
    1 × SELECT parent.id, parent.lft, parent.rgt
      FROM JOOM_usergroups AS parent
    1 × SELECT *
      FROM `JOOM_comprofiler_plugin_autoactions`
    1 × SELECT *
      FROM `JOOM_comprofiler_plugin`
    1 × SELECT b.rules
      FROM JOOM_assets AS a
      LEFT JOIN JOOM_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt

Autres tables :

    1 × UPDATE `JOOM_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:25;s:19:\"session.timer.start\";i:1367615847;s:18:\"session.timer.last\";i:1367616665;s:17:\"session.timer.now\";i:1367616668;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";s:3:\"104\";s:4:\"name\";s:5:\"Gorgo\";s:8:\"username\";s:5:\"Gorgo\";s:5:\"email\";s:15:\"olivier@sohy.be\";s:8:\"password\";s:65:\"d6a81cdc8a3225d8d31f056c131ee498:YG9uut0CtBRbedkJrdooCCXi8m1JybhC\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-14 10:31:13\";s:13:\"lastvisitDate\";s:19:\"2013-05-03 21:17:32\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:108:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"Europe\\/Brussels\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";N;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";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:15:\"Europe/Brussels\";}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}}s:13:\"session.token\";s:32:\"da98be3d4a493a80ae0d6a80766c46b5\";}RESET_PHPBB_CACHE|i:1;' , `time` = '1367616668'
    1 × SHOW FULL COLUMNS
      FROM `JOOM_komento_configs
    1 × SHOW FULL COLUMNS
      FROM `JOOM_assets
    1 × SHOW FULL COLUMNS
      FROM `JOOM_users
    1 × INSERT INTO `JOOM_rokuserstats` (`user_id`,`ip`,`session_id`,`page`,`referrer`)
      VALUES ('104','109.128.40.184','sm1fpajpodtrdo3h06elpt2872','/mon-profile','http://www.teso-mmo.fr/mon-profile/userdetails'