1. La ligne de la base de données est vide.
   

   Call stack
   #	Function	Location
   1	JSite->dispatch()	JROOT/index.php:42
   2	JComponentHelper::renderComponent()	JROOT/includes/application.php:194
   3	JComponentHelper::executeComponent()	JROOT/libraries/joomla/application/component/helper.php:348
   4	require_once()	JROOT/libraries/joomla/application/component/helper.php:380
   5	JController->execute()	JROOT/components/com_content/content.php:16
   6	ContentController->display()	JROOT/libraries/joomla/application/component/controller.php:761
   7	JController->display()	JROOT/components/com_content/controller.php:74
   8	JCacheControllerView->get()	JROOT/libraries/joomla/application/component/controller.php:718
   9	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
   10	JDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:121
   11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:161
   12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:71
   13	plgContentCCK->onContentPrepare()
   14	plgContentCCK->_prepare()	JROOT/plugins/content/cck/cck.php:215
   15	plgContentCCK->_render()	JROOT/plugins/content/cck/cck.php:362
   16	JDispatcher->trigger()	JROOT/plugins/content/cck/cck.php:464
   17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:161
   18	call_user_func_array()	JROOT/libraries/joomla/event/event.php:71
   19	plgCCK_Storage_LocationFree->onCCK_Storage_LocationPrepareContent()
   20	JCckPluginLocation->g_onCCK_Storage_LocationPrepareContent()	JROOT/plugins/cck_storage_location/free/free.php:66
   21	JCckTable->load()	JROOT/libraries/cms/cck/plugin/location.php:93
   22	JTable->load()	JROOT/libraries/cms/cck/table.php:59

89 requêtes exécutées

1. SELECT `data`
  FROM `pc17_session`
  WHERE `session_id` = '4d108943ce67436307d46edcf4878a2b'
2. SELECT `session_id`
  FROM `pc17_session`
  WHERE `session_id` = '4d108943ce67436307d46edcf4878a2b'
  LIMIT 0, 1
3. INSERT INTO `pc17_session` (`session_id`, `client_id`, `time`)
  VALUES ('4d108943ce67436307d46edcf4878a2b', 0, '1524735822')
4. SELECT b.id
  FROM pc17_usergroups AS a
  LEFT JOIN pc17_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
5. SELECT id, rules
  FROM `pc17_viewlevels`
6. SELECT `path`
  FROM pc17_rsfirewall_ignored
  WHERE `type`='ignore_folder' OR `type`='ignore_file'
7. SELECT `file`
  FROM pc17_rsfirewall_hashes
  WHERE `type`='protect'
8. SELECT *
  FROM pc17_rsfirewall_configuration
9. SHOW FULL COLUMNS
  FROM `pc17_rsfirewall_logs`
10. SELECT extension_id
  FROM pc17_extensions
  WHERE type = "component"
  AND element = "com_cck_webservices"
11. SELECT extension_id
  FROM pc17_extensions
  WHERE type = "component"
  AND element = "com_cck_toolbox"
12. SELECT type, scriptfile, options
  FROM pc17_cck_more_processings
  WHERE published = 1
  ORDER BY ordering
13. 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 pc17_menu AS m
  LEFT JOIN pc17_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
14. SELECT a.storage_location, a.options
  FROM pc17_cck_core_searchs AS a
  WHERE a.name = "techniques2"
15. SELECT a.id
  FROM pc17_content AS a
  LEFT JOIN pc17_categories AS b
  on b.id = a.catid
  WHERE a.alias = "piquer-a-la-machine"
  AND b.alias = "les-techniques-de-base"
16. SELECT `id`
  FROM `pc17_usergroups`
17. SELECT a.rules
  FROM pc17_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
18. SELECT DISTINCT(user_id)
  FROM pc17_usergroups as ug1
  INNER JOIN pc17_usergroups AS ug2
  ON ug2.lft>=ug1.lft
  AND ug1.rgt>=ug2.rgt
  INNER JOIN pc17_user_usergroup_map AS m
  ON ug2.id=m.group_id
  WHERE ug1.id='6'
19. SELECT DISTINCT(user_id)
  FROM pc17_usergroups as ug1
  INNER JOIN pc17_usergroups AS ug2
  ON ug2.lft>=ug1.lft
  AND ug1.rgt>=ug2.rgt
  INNER JOIN pc17_user_usergroup_map AS m
  ON ug2.id=m.group_id
  WHERE ug1.id='8'
20. SELECT u.*
  FROM pc17_users u
  WHERE u.id IN (42)
  ORDER BY u.username ASC
21. SELECT *
  FROM pc17_rsfirewall_hashes
  WHERE (`type`='2.5.28' OR `type`='protect')
  AND `flag`!='C'
22. SELECT *
  FROM pc17_rsfirewall_snapshots
  WHERE `type`='protect'
23. SELECT `ip`,`reason`
  FROM pc17_rsfirewall_lists
  WHERE (`ip`='54.156.37.174' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
  AND `type`='1'
  AND `published`='1'
24. SELECT `ip`,`reason`
  FROM pc17_rsfirewall_lists
  WHERE (`ip`='54.156.37.174' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
  AND `type`='0'
  AND `published`='1'
25. SELECT *
  FROM pc17_rsfirewall_exceptions
  WHERE `published`='1'
26. SELECT COUNT(*)
  FROM pc17_jantispam_banip
  WHERE bannedip = '54.156.37.174'
27. SELECT a.rules
  FROM pc17_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
28. SELECT b.rules
  FROM pc17_assets AS a
  LEFT JOIN pc17_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_jantispam')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
29. SELECT b.rules
  FROM pc17_assets AS a
  LEFT JOIN pc17_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
30. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 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.parentid, 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,( SELECT MAX(contact.id) AS id
  FROM pc17_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by) as contactid,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 pc17_content AS a
  LEFT JOIN pc17_categories AS c
  on c.id = a.catid
  LEFT JOIN pc17_users AS u
  on u.id = a.created_by
  LEFT JOIN pc17_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN pc17_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM pc17_categories AS cat JOIN pc17_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published <= 0
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE a.id = 39
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-26 09:43:42')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-26 09:43:42')
  AND (a.state = 1 OR a.state =2)
31. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM pc17_categories as c
  LEFT JOIN pc17_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 pc17_categories AS cat JOIN pc17_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)
  AND c.published = 1
  AND s.id=12
  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
32. SELECT a.id, a.pk, a.pkb, a.cck, a.storage_location, a.store_id, a.author_id AS author, b.id AS type_id, b.alias AS type_alias, b.indexed, b.parent, b.stylesheets, b.options_content, b.options_intro, c.template AS content_template, c.params AS content_params, d.template AS intro_template, d.params AS intro_params, f.app as folder_app
  FROM pc17_cck_core AS a
  LEFT JOIN pc17_cck_core_types AS b
  ON b.name = a.cck
  LEFT JOIN pc17_template_styles AS c
  ON c.id = b.template_content
  LEFT JOIN pc17_template_styles AS d
  ON d.id = b.template_intro
  LEFT JOIN pc17_cck_core_folders AS f
  ON f.id = b.folder
  WHERE a.id = "798"
33. SELECT cc.*, c.label as label2, c.variation, c.link, c.link_options, c.markup, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.restriction, c.restriction_options, c.position
  FROM pc17_cck_core_type_field AS c
  LEFT JOIN pc17_cck_core_types AS sc
  ON sc.id = c.typeid
  LEFT JOIN pc17_cck_core_fields AS cc
  ON cc.id = c.fieldid
  WHERE sc.name = "article"
  AND sc.published = 1
  AND c.client = "content"
  AND c.access IN (1,1)
  ORDER BY c.ordering ASC
34. SELECT *
  FROM pc17_cck_core_type_position AS a
  LEFT JOIN pc17_cck_core_types AS b
  ON b.id = a.typeid
  WHERE b.name = "article"
  AND a.client ="content"
35. SHOW FULL COLUMNS
  FROM `pc17_content`
36. SELECT *
  FROM pc17_content
  WHERE `id` = '39'
37. SELECT a.title, a.alias
  FROM pc17_categories AS a
  WHERE a.id = 12
38. SELECT b.alias as author_alias
  FROM pc17_cck_core AS a
  LEFT JOIN pc17_content AS b
  ON b.id = a.pkb
  WHERE a.storage_location = "joomla_user"
  AND a.pk = 0
39. SHOW FULL COLUMNS
  FROM `pc17_cck_store_item_content`
40. SELECT *
  FROM pc17_cck_store_item_content
  WHERE `id` = '39'
41. SELECT DISTINCT a.*, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.live, c.live_options, c.live_value, c.link, c.link_options, c.typo, c.typo_label, c.typo_options, c.markup, c.markup_class, c.stage, c.access, c.restriction, c.restriction_options, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position
  FROM pc17_cck_core_fields AS a
  LEFT JOIN pc17_cck_core_type_field AS c
  ON c.fieldid = a.id
  LEFT JOIN pc17_cck_core_types AS b
  ON b.id = c.typeid
  WHERE c.client = "content"
  AND b.name = "etape"
  AND a.type != "form_action"
  AND c.access IN (1,1)
  ORDER BY c.ordering ASC
42. SELECT a.*
  FROM pc17_cck_core_fields AS a
  WHERE a.name="etapeimage"
43. SELECT name,catid
  FROM pc17_joomgallery_classif
  WHERE type="difficulte"
44. SELECT name,catid
  FROM pc17_joomgallery_classif
  WHERE type="destinataire"
45. SELECT name,catid
  FROM pc17_joomgallery_classif
  WHERE type="type_vet"
46. SELECT t.text, t.v AS value
  FROM (SELECT 0 AS v,'non publié' AS text UNION SELECT 1 AS v,'publié' AS text) AS t;
47. SHOW FULL COLUMNS
  FROM `pc17_cck_store_item_cck_store_join_related_articles`
48. SELECT *
  FROM pc17_cck_store_item_cck_store_join_related_articles
  WHERE `id` = '39'
49. SELECT a.*
  FROM pc17_cck_core_fields AS a
  WHERE a.name="related_article"
50. SHOW FULL COLUMNS
  FROM `pc17_categories`
51. SELECT *
  FROM pc17_categories
  WHERE `id` = '39'
52. SELECT a.title, a.alias
  FROM pc17_categories AS a
  WHERE a.id = 1
53. SELECT name
  FROM pc17_users
  WHERE id = 0
54. SELECT b.rules
  FROM pc17_assets AS a
  LEFT JOIN pc17_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_cck.form.1')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
55. SELECT b.rules
  FROM pc17_assets AS a
  LEFT JOIN pc17_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_cck.form.1')
  ORDER BY b.lft
56. SELECT username
  FROM `pc17_users`
  WHERE `id`=0
57. SELECT avatar
  FROM `pc17_comprofiler`
  WHERE `id`=0
58. SELECT alias
  FROM pc17_content
  WHERE id=0
59. SELECT alias
  FROM pc17_categories
  WHERE id = 12
60. SELECT *
  FROM `pc17_comment_setting`
  WHERE set_component = 'com_content'
61. SELECT COUNT(*)
  FROM pc17_comment
  WHERE contentid='39'
  AND component='com_content'
  AND published = 1
  AND parentid<=0
  ORDER BY id DESC
62. SELECT *
  FROM pc17_comment
  WHERE contentid='39'
  AND component='com_content'
  AND published = 1
  AND parentid<=0
  ORDER BY id DESC
  LIMIT 0, 8
63. SELECT *
  FROM pc17_comment
  WHERE contentid='39'
  AND component='com_content'
  AND published = 1
  AND parentid>0
  ORDER BY id ASC
64. SELECT `u`.`username`,`c`.`user_id`,`c`.`avatar`
  FROM `pc17_users`AS u, `pc17_comprofiler`AS c
  WHERE `u`.`id`=`c`.`user_id`
  AND `u`.`id` IN (79569,79569,41738)
65. SELECT *
  FROM pc17_users
  WHERE id='79569'
  LIMIT 1
66. SELECT id
  FROM pc17_menu
  WHERE link LIKE '%option=com_community%'
  AND type = 'component'
  AND published = 1
  LIMIT 1
67. SELECT`username`
  FROM `pc17_users`
  WHERE `id` = 79569
  LIMIT 0, 1
68. SELECT id
  FROM pc17_menu
  WHERE link LIKE '%option=com_community%'
  AND type = 'component'
  AND published = 1
  LIMIT 1
69. SELECT`username`
  FROM `pc17_users`
  WHERE `id` = 79569
  LIMIT 0, 1
70. SELECT *
  FROM pc17_users
  WHERE id='79569'
  LIMIT 1
71. SELECT id
  FROM pc17_menu
  WHERE link LIKE '%option=com_community%'
  AND type = 'component'
  AND published = 1
  LIMIT 1
72. SELECT`username`
  FROM `pc17_users`
  WHERE `id` = 79569
  LIMIT 0, 1
73. SELECT id
  FROM pc17_menu
  WHERE link LIKE '%option=com_community%'
  AND type = 'component'
  AND published = 1
  LIMIT 1
74. SELECT`username`
  FROM `pc17_users`
  WHERE `id` = 79569
  LIMIT 0, 1
75. SELECT *
  FROM pc17_users
  WHERE id='41738'
  LIMIT 1
76. SELECT id
  FROM pc17_menu
  WHERE link LIKE '%option=com_community%'
  AND type = 'component'
  AND published = 1
  LIMIT 1
77. SELECT`username`
  FROM `pc17_users`
  WHERE `id` = 41738
  LIMIT 0, 1
78. SELECT id
  FROM pc17_menu
  WHERE link LIKE '%option=com_community%'
  AND type = 'component'
  AND published = 1
  LIMIT 1
79. SELECT`username`
  FROM `pc17_users`
  WHERE `id` = 41738
  LIMIT 0, 1
80. SELECT COUNT(*)
  FROM pc17_comment
  WHERE contentid='39'
  AND component='com_content'
  AND published='1'
81. SELECT COUNT(*)
  FROM pc17_comment
  WHERE contentid='39'
  AND component='com_content'
  AND published='1'
82. UPDATE pc17_content
  SET hits = hits + 1
  WHERE id = 39
83. SELECT DISTINCT a.id as article_id, a.title as article_title, a.alias as article_alias, a.language as article_language, a.featured as article_featured, a.hits as article_hits, a.version as article_version, a.created_by as article_created_by, a.modified_by as article_modified_by, a.introtext as article_introtext, a.fulltext as article_fulltext, a.created as article_created, a.modified as article_modified, a.publish_up as article_publishup, a.publish_down as article_publishdown, a.metakey as article_metakeywords, a.metadesc as article_metadescription, floor(time_to_sec(timediff(now(),a.created))/60) as article_created_age, floor(time_to_sec(timediff(now(),a.modified))/60) as article_modified_age, a.catid as category_id, cat1.title as category_title, cat1.alias as category_alias, cat1.language as category_language, cat1.description as category_description, cat1.note as category_note, cat1.title as ct1, cat1.id as ci1, cat2.title as ct2, cat2.id as ci2, cat3.title as ct3, cat3.id as ci3, cat4.title as ct4, cat4.id as ci4, cat5.title as ct5, cat5.id as ci5, cat6.title as ct6, cat6.id as ci6, cat7.title as ct7, cat7.id as ci7, cat8.title as ct8, cat8.id as ci8
  FROM `pc17_content` a
  LEFT JOIN `pc17_categories` cat1
  ON a.catid = cat1.id
  LEFT JOIN `pc17_categories` cat2
  ON cat1.parent_id = cat2.id
  LEFT JOIN `pc17_categories` cat3
  ON cat2.parent_id = cat3.id
  LEFT JOIN `pc17_categories` cat4
  ON cat3.parent_id = cat4.id
  LEFT JOIN `pc17_categories` cat5
  ON cat4.parent_id = cat5.id
  LEFT JOIN `pc17_categories` cat6
  ON cat5.parent_id = cat6.id
  LEFT JOIN `pc17_categories` cat7
  ON cat6.parent_id = cat7.id
  LEFT JOIN `pc17_categories` cat8
  ON cat7.parent_id = cat8.id
  WHERE a.id = '39'
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-26 09:43:42' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-26 09:43:42' )
  LIMIT 0, 1
84. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, m.published, m.ordering, m.id in ( '177','184' ) as in_id, m.position in ( '177','184' ) as in_position
  FROM pc17_modules AS m
  WHERE m.access IN (1,1)
  AND ( m.id in ( '177','184' ) OR m.position in ( '177','184' ) )
  ORDER BY ( field(
  case when m.position in ( '177','184' ) then m.position else m.id end, '177','184' )), m.ordering
85. SHOW FULL COLUMNS
  FROM `pc17_jnews_xonfig`
86. SELECT *
  FROM `pc17_jnews_xonfig`
87. SELECT`username`
  FROM `pc17_users`
  WHERE `id` = 0
  LIMIT 0, 1
88. SELECT`username`
  FROM `pc17_users`
  WHERE `id` = 0
  LIMIT 0, 1
89. UPDATE `pc17_session`
  SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1524735822;s:18:\"session.timer.last\";i:1524735822;s:17:\"session.timer.now\";i:1524735822;s:24:\"session.client.forwarded\";s:13:\"54.156.37.174\";s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:10:\"session_id\";s:32:\"4d108943ce67436307d46edcf4878a2b\";s:12:\"where_clause\";s:45:\"session_id=\"4d108943ce67436307d46edcf4878a2b\"\";s:2:\"ip\";s:13:\"54.156.37.174\";}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:16:\"com_mailto.links\";a:2:{s:40:\"7e0aa25400c021d1fc23b4d9a1aabee0fcb45c27\";O:8:\"stdClass\":2:{s:4:\"link\";s:76:\"http://www.petitcitron.com/index.php/blog-techniques/les-techniques-de-base/\";s:6:\"expiry\";i:1524735823;}s:40:\"c477ff3d0eeaa9753722fea9d2a2c39f2c02be68\";O:8:\"stdClass\":2:{s:4:\"link\";s:95:\"http://www.petitcitron.com/index.php/blog-techniques/les-techniques-de-base/piquer-a-la-machine\";s:6:\"expiry\";i:1524735823;}}s:13:\"session.token\";s:32:\"87500f3a62346d5abe5ff328d5d22e69\";}' , `time` = '1524735823'
  WHERE `session_id` = '4d108943ce67436307d46edcf4878a2b'

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

Tables sélectionnées :

1. 8 × SELECT`username`
  FROM `pc17_users`
2. 6 × SELECT id
  FROM pc17_menu
3. 4 × SELECT b.rules
  FROM pc17_assets AS a
  LEFT JOIN pc17_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
4. 3 × SELECT name,catid
  FROM pc17_joomgallery_classif
5. 3 × SELECT *
  FROM pc17_users
6. 2 × SELECT a.rules
  FROM pc17_assets AS a
7. 2 × SELECT `ip`,`reason`
  FROM pc17_rsfirewall_lists
8. 2 × SELECT a.title, a.alias
  FROM pc17_categories AS a
9. 2 × SELECT *
  FROM pc17_comment
10. 2 × SELECT a.*
  FROM pc17_cck_core_fields AS a
11. 2 × SELECT DISTINCT(user_id)
  FROM pc17_usergroups as ug1
  INNER JOIN pc17_usergroups AS ug2
  ON ug2.lft>=ug1.lft
  AND ug1.rgt>=ug2.rgt
  INNER JOIN pc17_user_usergroup_map AS m
  ON ug2.id=m.group_id
12. 2 × SELECT COUNT(*)
  FROM pc17_comment
13. 2 × SELECT extension_id
  FROM pc17_extensions
14. 1 × SELECT *
  FROM pc17_categories
15. 1 × SELECT *
  FROM pc17_cck_store_item_cck_store_join_related_articles
16. 1 × SELECT t.text, t.v AS value
  FROM (SELECT 0 AS v,'non publié' AS text UNION SELECT 1 AS v,'publié' AS text) AS t
17. 1 × SELECT DISTINCT a.id as article_id, a.title as article_title, a.alias as article_alias, a.language as article_language, a.featured as article_featured, a.hits as article_hits, a.version as article_version, a.created_by as article_created_by, a.modified_by as article_modified_by, a.introtext as article_introtext, a.fulltext as article_fulltext, a.created as article_created, a.modified as article_modified, a.publish_up as article_publishup, a.publish_down as article_publishdown, a.metakey as article_metakeywords, a.metadesc as article_metadescription, floor(time_to_sec(timediff(now(),a.created))/60) as article_created_age, floor(time_to_sec(timediff(now(),a.modified))/60) as article_modified_age, a.catid as category_id, cat1.title as category_title, cat1.alias as category_alias, cat1.language as category_language, cat1.description as category_description, cat1.note as category_note, cat1.title as ct1, cat1.id as ci1, cat2.title as ct2, cat2.id as ci2, cat3.title as ct3, cat3.id as ci3, cat4.title as ct4, cat4.id as ci4, cat5.title as ct5, cat5.id as ci5, cat6.title as ct6, cat6.id as ci6, cat7.title as ct7, cat7.id as ci7, cat8.title as ct8, cat8.id as ci8
  FROM `pc17_content` a
  LEFT JOIN `pc17_categories` cat1
  ON a.catid = cat1.id
  LEFT JOIN `pc17_categories` cat2
  ON cat1.parent_id = cat2.id
  LEFT JOIN `pc17_categories` cat3
  ON cat2.parent_id = cat3.id
  LEFT JOIN `pc17_categories` cat4
  ON cat3.parent_id = cat4.id
  LEFT JOIN `pc17_categories` cat5
  ON cat4.parent_id = cat5.id
  LEFT JOIN `pc17_categories` cat6
  ON cat5.parent_id = cat6.id
  LEFT JOIN `pc17_categories` cat7
  ON cat6.parent_id = cat7.id
  LEFT JOIN `pc17_categories` cat8
  ON cat7.parent_id = cat8.id
18. 1 × SELECT *
  FROM `pc17_jnews_xonfig
19. 1 × SELECT DISTINCT a.*, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.live, c.live_options, c.live_value, c.link, c.link_options, c.typo, c.typo_label, c.typo_options, c.markup, c.markup_class, c.stage, c.access, c.restriction, c.restriction_options, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position
  FROM pc17_cck_core_fields AS a
  LEFT JOIN pc17_cck_core_type_field AS c
  ON c.fieldid = a.id
  LEFT JOIN pc17_cck_core_types AS b
  ON b.id = c.typeid
20. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, m.published, m.ordering, m.id in ( '177','184' ) as in_id, m.position in ( '177','184' ) as in_position
  FROM pc17_modules AS m
21. 1 × SELECT username
  FROM `pc17_users`
22. 1 × SELECT *
  FROM pc17_cck_store_item_content
23. 1 × SELECT `u`.`username`,`c`.`user_id`,`c`.`avatar`
  FROM `pc17_users`AS u, `pc17_comprofiler`AS c
24. 1 × SELECT *
  FROM `pc17_comment_setting`
25. 1 × SELECT alias
  FROM pc17_categories
26. 1 × SELECT alias
  FROM pc17_content
27. 1 × SELECT COUNT(*)
  FROM pc17_comment
28. 1 × SELECT avatar
  FROM `pc17_comprofiler`
29. 1 × SELECT name
  FROM pc17_users
30. 1 × SELECT *
  FROM pc17_cck_core_type_position AS a
  LEFT JOIN pc17_cck_core_types AS b
  ON b.id = a.typeid
31. 1 × SELECT type, scriptfile, options
  FROM pc17_cck_more_processings
32. 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 pc17_menu AS m
  LEFT JOIN pc17_extensions AS e
  ON m.component_id = e.extension_id
33. 1 × SELECT a.storage_location, a.options
  FROM pc17_cck_core_searchs AS a
34. 1 × SELECT a.id
  FROM pc17_content AS a
  LEFT JOIN pc17_categories AS b
  on b.id = a.catid
35. 1 × SELECT *
  FROM pc17_rsfirewall_configuratio
36. 1 × SELECT `file`
  FROM pc17_rsfirewall_hashes
37. 1 × SELECT `session_id`
  FROM `pc17_session`
38. 1 × SELECT b.id
  FROM pc17_usergroups AS a
  LEFT JOIN pc17_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
39. 1 × SELECT id, rules
  FROM `pc17_viewlevels
40. 1 × SELECT `path`
  FROM pc17_rsfirewall_ignored
41. 1 × SELECT `id`
  FROM `pc17_usergroups
42. 1 × SELECT u.*
  FROM pc17_users u
43. 1 × SELECT a.id, a.pk, a.pkb, a.cck, a.storage_location, a.store_id, a.author_id AS author, b.id AS type_id, b.alias AS type_alias, b.indexed, b.parent, b.stylesheets, b.options_content, b.options_intro, c.template AS content_template, c.params AS content_params, d.template AS intro_template, d.params AS intro_params, f.app as folder_app
  FROM pc17_cck_core AS a
  LEFT JOIN pc17_cck_core_types AS b
  ON b.name = a.cck
  LEFT JOIN pc17_template_styles AS c
  ON c.id = b.template_content
  LEFT JOIN pc17_template_styles AS d
  ON d.id = b.template_intro
  LEFT JOIN pc17_cck_core_folders AS f
  ON f.id = b.folder
44. 1 × SELECT cc.*, c.label as label2, c.variation, c.link, c.link_options, c.markup, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.restriction, c.restriction_options, c.position
  FROM pc17_cck_core_type_field AS c
  LEFT JOIN pc17_cck_core_types AS sc
  ON sc.id = c.typeid
  LEFT JOIN pc17_cck_core_fields AS cc
  ON cc.id = c.fieldid
45. 1 × SELECT `data`
  FROM `pc17_session`
46. 1 × SELECT *
  FROM pc17_content
47. 1 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM pc17_categories as c
  LEFT JOIN pc17_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 pc17_categories AS cat JOIN pc17_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
48. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 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.parentid, 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,( SELECT MAX(contact.id) AS id
  FROM pc17_contact_details AS contact
49. 1 × SELECT *
  FROM pc17_rsfirewall_hashes
50. 1 × SELECT *
  FROM pc17_rsfirewall_snapshots
51. 1 × SELECT *
  FROM pc17_rsfirewall_exceptions
52. 1 × SELECT COUNT(*)
  FROM pc17_jantispam_banip
53. 1 × SELECT b.alias as author_alias
  FROM pc17_cck_core AS a
  LEFT JOIN pc17_content AS b
  ON b.id = a.pkb

Autres tables :

1. 1 × UPDATE pc17_content
  SET hits = hits + 1
2. 1 × SHOW FULL COLUMNS
  FROM `pc17_jnews_xonfig
3. 1 × UPDATE `pc17_session`
  SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1524735822;s:18:\"session.timer.last\";i:1524735822;s:17:\"session.timer.now\";i:1524735822;s:24:\"session.client.forwarded\";s:13:\"54.156.37.174\";s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:10:\"session_id\";s:32:\"4d108943ce67436307d46edcf4878a2b\";s:12:\"
4. 1 × SHOW FULL COLUMNS
  FROM `pc17_categories
5. 1 × SHOW FULL COLUMNS
  FROM `pc17_cck_store_item_cck_store_join_related_articles
6. 1 × SHOW FULL COLUMNS
  FROM `pc17_rsfirewall_logs
7. 1 × SHOW FULL COLUMNS
  FROM `pc17_content
8. 1 × SHOW FULL COLUMNS
  FROM `pc17_cck_store_item_content
9. 1 × INSERT INTO `pc17_session` (`session_id`, `client_id`, `time`)
  VALUES ('4d108943ce67436307d46edcf4878a2b', 0, '1524735822'