Console de depuração do Joomla!

70 Queries Registradas

1. SELECT `data`
  FROM `joom_session`
  WHERE `session_id` = '41bc0cab9640be4b71b229b668a11ab5'
2. DELETE
  FROM `joom_session`
  WHERE `time` < '1369545179'
3. SELECT `session_id`
  FROM `joom_session`
  WHERE `session_id` = '41bc0cab9640be4b71b229b668a11ab5'
  LIMIT 0, 1
4. INSERT INTO `joom_session` (`session_id`, `client_id`, `time`)
  VALUES ('41bc0cab9640be4b71b229b668a11ab5', 0, '1369548779')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM joom_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM joom_usergroups AS a
  LEFT JOIN joom_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `joom_viewlevels`
8. 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)
  ORDER BY ordering
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM joom_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM joom_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
11. SELECT extension_id AS id, element AS "option", params, enabled
  FROM joom_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_zoo'
12. SHOW TABLES
13. SELECT file_id
  from joom_jdownloads_files
  WHERE published = 1
  AND use_timeframe = 1
  AND publish_to != '0000-00-00 00:00:00'
  AND publish_to <= '2013-05-26 03:12:59'
14. SELECT file_id
  from joom_jdownloads_files
  WHERE published = 0
  AND use_timeframe = 1
  AND publish_from != '0000-00-00 00:00:00'
  AND publish_from <= '2013-05-26 03:12:59'
15. 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
16. SHOW TABLES
17. SELECT a.rules
  FROM joom_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
18. 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 = 'com_k2' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
19. SELECT id
  FROM joom_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
20. SHOW FULL COLUMNS
  FROM `joom_k2_categories`
21. SELECT *
  FROM joom_k2_categories
  WHERE id = '2'
22. SELECT *
  FROM joom_k2_categories
  WHERE parent=2
  AND published=1
  AND trash=0
  AND access IN(1,1)
  ORDER BY id ASC
23. SELECT id
  FROM joom_k2_categories
  WHERE parent IN (2)
  AND id NOT IN (2)
  AND published=1
  AND trash=0
  AND access IN(1,1)
24. SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM joom_k2_items as i RIGHT JOIN joom_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-05-26 06:13:00' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-05-26 06:13:00' )
  AND c.id IN (2)
  ORDER BY i.id DESC
  LIMIT 0, 14
25. SELECT COUNT(*)
  FROM joom_k2_items as i RIGHT JOIN joom_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-05-26 06:13:00' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-05-26 06:13:00' )
  AND c.id IN (2)
26. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 97
  ORDER BY xref.id ASC
27. SHOW FULL COLUMNS
  FROM `joom_users`
28. SELECT *
  FROM `joom_users`
  WHERE `id` = 42
29. SELECT `g`.`id`,`g`.`title`
  FROM `joom_usergroups` AS g
  INNER JOIN `joom_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 42
30. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM joom_k2_users
  WHERE userID=42
31. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=97
  AND published=1
32. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 93
  ORDER BY xref.id ASC
33. SELECT *
  FROM `joom_users`
  WHERE `id` = 47
34. SELECT `g`.`id`,`g`.`title`
  FROM `joom_usergroups` AS g
  INNER JOIN `joom_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 47
35. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM joom_k2_users
  WHERE userID=47
36. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=93
  AND published=1
37. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 88
  ORDER BY xref.id ASC
38. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=88
  AND published=1
39. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 87
  ORDER BY xref.id ASC
40. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=87
  AND published=1
41. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 45
  ORDER BY xref.id ASC
42. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=45
  AND published=1
43. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 38
  ORDER BY xref.id ASC
44. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=38
  AND published=1
45. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 36
  ORDER BY xref.id ASC
46. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=36
  AND published=1
47. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 28
  ORDER BY xref.id ASC
48. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=28
  AND published=1
49. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 27
  ORDER BY xref.id ASC
50. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=27
  AND published=1
51. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 25
  ORDER BY xref.id ASC
52. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=25
  AND published=1
53. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 24
  ORDER BY xref.id ASC
54. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=24
  AND published=1
55. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 21
  ORDER BY xref.id ASC
56. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=21
  AND published=1
57. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 20
  ORDER BY xref.id ASC
58. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=20
  AND published=1
59. SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 19
  ORDER BY xref.id ASC
60. SELECT COUNT(*)
  FROM joom_k2_comments
  WHERE itemID=19
  AND published=1
61. SHOW FULL COLUMNS
  FROM `joom_community_config`
62. SELECT *
  FROM joom_community_config
  WHERE `name` = 'config'
63. SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
  FROM `joom_community_users` as a
  LEFT JOIN `joom_users` u
  ON u.`id`=a.`userid`
  LEFT
  OUTER JOIN `joom_session` s
  ON s.`userid`=a.`userid`
  AND s.`client_id` !='1'
  WHERE a.`userid`='0'
64. SHOW FULL COLUMNS
  FROM `joom_community_profiles`
65. SELECT extension_id AS id, element AS "option", params, enabled
  FROM joom_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_joomdle'
66. SHOW TABLES
67. SELECT extension_id AS id, element AS "option", params, enabled
  FROM joom_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_dump'
68. select *
  from joom_clickdesk
  limit 1
69. select *
  from joom_clickdesk
  limit 1
70. UPDATE `joom_session`
  SET `data` = 'ab8KTWVD9QOvikHDKtNLjDJxHExBviR1LQ15H1AG5HeHLAQ8kqLmlPE38i5WfTULSuh-3YBWnno27qkYZjoO_FOb2KInXwapp4AO6shSgV8dxE2Ox2-zQdZaaD5AFB39jfJNAKjOQP7EdJpcW4o0FrgTBcdwTG85Ur72ENn71ApROeGjIhrFjFGPRQjeh7pMmr_rOHKpqjzTLqUXV41TKuu8dVmaFkfMrH4Au2IbjiR0f1LWN98qKm5m-fuAqI7__3s_aRHOhmyMeN08AE1rGWj3S8qJQLFoGbAEkPwcZSr9m3JAZA4ml5lpVkvERs653dnjsmHtYJXYhI0-KH1hV-zdwnG8acVD1MvsKyRXwQ5dhoZRfcru5BmwD6coTqd929AcPzdCu6FJJ0WR-MRxBSPYOjaHwKH0d2g1uVUkzl4aU4P_UVskm8usCHfIir3Hljqh-m6072Sn3OjVwBluq_P0NYHVGdFIun9qTuZHVcOV_wMBfaNf1zvd1P7WHzIIVqRttXLdpU84ywW9MCoClH5POmRTBE6-ByEQtDbCETPqwVl0cwcq2_qr6nUPyt_P30ZCfwHnu9yjKMWOPvCJnBaQLQASSFw-0uA-D9WvnoysduLM-bC-AJbU1aFMB6-iXAW5ZXBYrd5yjb6Wt4zXMZvmwEqrSE6Ny8X5c-LaYimwSI7v2k3cN8Mas2PphvonWfQ57yIjUWK2t1SDnfJBPGjBj-OQqSwgnYNzhR3FcohzdzdBy34XI9rSCYUGTin1iQlom2O3mNsC8IdzXIfwSQ72dEUfKgUBxNwxE0LX5GQHIOxbXGfhWFHpUjXcZ6uR7-Y61Mxp67p3a3GTPtgHQ2-zDFBeB2YQYa2oaVxJxP8RFVJz0PUZpubTeBXBTkNZHHadqB-52_y8OrnKuVenogjp-wOZyKZLcsuHGbFAZM4r0OMt5WYQse5YXwmPR9ILJonCWArCBa1X3pQJdB-iNWvCU1j3ufjuNsIPlF448r7Hrr9USRHrSLkx7PtRCB_ktKbvuPDFx7pnbtRrmJh3JMfevNEDrrAsXbXGy113NNn2xoNwgvVR8QExcaOah6U30JynDNfZC8Nllzm80LH0qNLg7wh5YHwm2bGHobIhSzmNk325YbgTLXwqLckOlGjcY5Scyc2K5AYjQ3SgLfC4ekU5ulrUgc4h-2pBnKgjdbLC2ojTfwK25Lag4DkUR4CZoUc6MXnD3vTxzbvJzR6Lp1GZpnfGx57E1prkIc8bGAOiMBSqxT0rSi6DO-NJqaGcF9NwiuOBS8N2ZOylYRFdDA..' , `time` = '1369548782'
  WHERE `session_id` = '41bc0cab9640be4b71b229b668a11ab5'

31 tipos de query registradas, sorteadas por ocorrências DESC

SELECT Tables:

1. 14 × SELECT tag.*
  FROM joom_k2_tags AS tag JOIN joom_k2_tags_xref AS xref
  ON tag.id = xref.tagID
2. 14 × SELECT COUNT(*)
  FROM joom_k2_comments
3. 6 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM joom_extensions
4. 2 × SELECT *
  FROM `joom_users`
5. 2 × SELECT `g`.`id`,`g`.`title`
  FROM `joom_usergroups` AS g
  INNER JOIN `joom_user_usergroup_map` AS m
  ON m.group_id = g.id
6. 2 × SELECT id, gender, description, image, url, `
  group`, plugins
  FROM joom_k2_users
7. 2 × select *
  from joom_clickdesk
  limit
8. 2 × SELECT *
  FROM joom_k2_categories
9. 2 × SELECT file_id
  from joom_jdownloads_files
10. 1 × SELECT id, rules
  FROM `joom_viewlevels
11. 1 × SELECT folder AS type, element AS name, params
  FROM joom_extensions
12. 1 × SELECT b.id
  FROM joom_usergroups AS a
  LEFT JOIN joom_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
13. 1 × SELECT *
  FROM joom_community_config
14. 1 × SELECT `session_id`
  FROM `joom_session`
15. 1 × SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
  FROM `joom_community_users` as a
  LEFT JOIN `joom_users` u
  ON u.`id`=a.`userid`
  LEFT
  OUTER JOIN `joom_session` s
  ON s.`userid`=a.`userid`
  AND s.`client_id` !='1'
16. 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
17. 1 × SELECT id
  FROM joom_k2_categories
18. 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
19. 1 × SELECT `data`
  FROM `joom_session`
20. 1 × SELECT id
  FROM joom_k2_categories
21. 1 × SELECT COUNT(*)
  FROM joom_k2_items as i RIGHT JOIN joom_k2_categories c
  ON c.id = i.catid
22. 1 × SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM joom_k2_items as i RIGHT JOIN joom_k2_categories AS c
  ON c.id = i.catid
23. 1 × SELECT a.rules
  FROM joom_assets AS a

Outras Tabelas:

1. 3 × SHOW TABLE
2. 1 × SHOW FULL COLUMNS
  FROM `joom_community_profiles
3. 1 × UPDATE `joom_session`
  SET `data` = 'ab8KTWVD9QOvikHDKtNLjDJxHExBviR1LQ15H1AG5HeHLAQ8kqLmlPE38i5WfTULSuh-3YBWnno27qkYZjoO_FOb2KInXwapp4AO6shSgV8dxE2Ox2-zQdZaaD5AFB39jfJNAKjOQP7EdJpcW4o0FrgTBcdwTG85Ur72ENn71ApROeGjIhrFjFGPRQjeh7pMmr_rOHKpqjzTLqUXV41TKuu8dVmaFkfMrH4Au2IbjiR0f1LWN98qKm5m-fuAqI7__3s_aRHOhmyMeN08AE1rGWj3S8qJQLFoGbAEkPwcZSr9m3JAZA4ml5lpVkvERs653dnjsmHtYJXYhI0-KH1hV-zdwnG8acVD1MvsKyRXwQ5dhoZRfcru5BmwD6coTqd929AcPzdCu6FJJ0WR-MRxBSPYOjaHwKH0d2g1uVUkzl4aU4P_UVskm8usCHfIir3Hljqh-m6072Sn3OjVwBluq_P0NYHVGdFIun9qTuZHVcOV_wMBfaNf1zvd1P7WHzIIVqRttXLdpU84ywW9MCoClH5POmRTBE6-ByEQtDbCETPqwVl0cwcq2_qr6nUPyt_P30ZCfwHnu9yjKMWOPvCJnBaQLQASSFw-0uA-D9WvnoysduLM-bC-AJbU1aFMB6-iXAW5ZXBYrd5yjb6Wt4zXMZvmwEqrSE6Ny8X5c-LaYimwSI7v2k3cN8Mas2PphvonWfQ57yIjUWK2t1SDnfJBPGjBj-OQqSwgnYNzhR3FcohzdzdBy34XI9rSCYUGTin1iQlom2O3mNsC8IdzXIfwSQ72dEUfKgUBxNwxE0LX5GQHIOxbXGfhWFHpUjXcZ6uR7-Y61Mxp67p3a3GTPtgHQ2-zDFBeB2YQYa2oaVxJxP8RFVJz0PUZpubTeBXBTkNZHHadqB-52_y8OrnKuVenogjp-wOZyKZLcsuHGbFAZM4r0OMt5WYQse5YXwmPR9ILJonCWArCBa1X3pQJdB-iNWvCU1j3ufjuNsIPlF448r7Hrr9USRHrSLkx7PtRCB_ktKbvuPDFx7pnbtRrmJh3JMfevNEDrrAsXbXGy113NNn2xoNwgvVR8QExcaOah6U30JynDNfZC8Nllzm80LH0qNLg7wh5YHwm2bGHobIhSzmNk325YbgTLXwqLckOlGjcY5Scyc2K5AYjQ3SgLfC4ekU5ulrUgc4h-2pBnKgjdbLC2ojTfwK25Lag4DkUR4CZoUc6MXnD3vTxzbvJzR6Lp1GZpnfGx57E1prkIc8bGAOiMBSqxT0rSi6DO-NJqaGcF9NwiuOBS8N2ZOylYRFdDA..' , `time` = '1369548782'
4. 1 × SHOW FULL COLUMNS
  FROM `joom_community_config
5. 1 × SHOW FULL COLUMNS
  FROM `joom_k2_categories
6. 1 × INSERT INTO `joom_session` (`session_id`, `client_id`, `time`)
  VALUES ('41bc0cab9640be4b71b229b668a11ab5', 0, '1369548779'
7. 1 × DELETE
  FROM `joom_session`
8. 1 × SHOW FULL COLUMNS
  FROM `joom_users