Consola de Joomla! Debug

23 Registro Consultas

1. SELECT `data`
  FROM `j25_session`
  WHERE `session_id` = '36e778e15516d62107c49e4066b55292'
2. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = '36e778e15516d62107c49e4066b55292'
  LIMIT 0, 1
3. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('36e778e15516d62107c49e4066b55292', 0, '1555913266')
4. SELECT b.id
  FROM j25_usergroups AS a
  LEFT JOIN j25_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
5. SELECT id, rules
  FROM `j25_viewlevels`
6. 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 j25_menu AS m
  LEFT JOIN j25_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
7. SELECT a.rules
  FROM j25_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
8. SELECT b.rules
  FROM j25_assets AS a
  LEFT JOIN j25_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_k2')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
9. SELECT id
  FROM j25_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
10. SELECT *
  FROM j25_k2_items
  WHERE id=255
  LIMIT 0, 1
11. SHOW FULL COLUMNS
  FROM `j25_k2_categories`
12. SELECT *
  FROM j25_k2_categories
  WHERE id = '70'
13. SELECT *
  FROM j25_k2_categories
  WHERE id = '126'
14. SELECT *
  FROM j25_k2_attachments
  WHERE itemID=255
15. SELECT *
  FROM j25_k2_rating
  WHERE itemID = 255
16. SELECT COUNT(*)
  FROM j25_k2_comments
  WHERE itemID=255
  AND published=1
17. SHOW FULL COLUMNS
  FROM `j25_k2_items`
18. UPDATE j25_k2_items
  SET `hits` = (`hits` + 1)
  WHERE id = '255'
19. SELECT *
  FROM j25_k2_items
  WHERE id != 255
  AND catid=70
  AND ordering > 4
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-04-22 06:07:46' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-04-22 06:07:46' )
  AND access IN(1,1)
  AND trash=0
  ORDER BY ordering ASC
  LIMIT 0, 1
20. SELECT *
  FROM j25_k2_items
  WHERE id != 255
  AND catid=70
  AND ordering < 4
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-04-22 06:07:46' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-04-22 06:07:46' )
  AND access IN(1,1)
  AND trash=0
  ORDER BY ordering DESC
  LIMIT 0, 1
21. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM j25_modules AS m
  LEFT JOIN j25_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN j25_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 <= '2019-04-22 06:07:46')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-04-22 06:07:46')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 263 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
22. SELECT guest, usertype, client_id
  FROM j25_session
  WHERE client_id = 0
23. UPDATE `j25_session`
  SET `data` = 'ib_6P3Zj-xY59uNFNw5GR7D2x9siBXVEW-pMC85xNpM2dXSmzrsgqF0mezRQpoNsZYWSpmNYLMGvQwCn8nu7ICXqh0Nubr7vvSVdk4ePjttOsz7GkcywKGDdLiokn_ODZTDASOt13Pc9VSaeXd61HWkBJyx7sJrIa60ipBSgSHNcjJ_Ni2eosBYRnavY5FXLxTFV9PUfQXPuP_4xQOo7EARCjAfF2PDZ7KXhTCqsSNTjJz8rapJLAFEGCzaZDF_mrAETj2-XfWC2zEnaGAY2nUz4YzcZ8GxcfJz46MylMrf44fo5c5jLWFjrhCLoBsfAiPLs-GMQ9iKskx5QfjAiHw6xrwIbxBqwmPJ8qpbrHCg0WMxTPMKeo0AwRC8u2qiadACqMejpfSZ-U9rUQ7oMTz0BhV2yahDZF8ae-_3GFztrCKd9rVA3CUcdRZH3LuBpRqiyoJ77FgouzQWc2ZnbCj6zL4sawT3O7BgUdm8BOOA_V5z9_WuhzNrUJVf3E9Ep9QWKn9jAQ9rnowASCq1ztH2j4dq67uoa5Bq-raX8hm1tZhS4QdkytZiX5vnFL8BieXo0XuVSR_aloXrwDogeA9BA2G0hDj-4oQ6uVkqSeRPLc1KYCDJqyCM76rZ-bVk1iPTgkD1SuzJdJLQQKr7sbBDB0IrvKLwvVyp7BcNBf_f34xKVmoL46BXrc9KD5PYtxpMXlMxSSw4CJYDLsFxsxX89CrF53KcnCMovbGogZU5zMgFlHutn8zoWjbadpkG_JN2UNFMNTtEs2tjniJChj7jyXTRef5SBCdrlsf-LA3z1HLKTU4l0bIPh20Nt3bfZkm--kvxduO57BOYp6LM8KlIGTZ2E-88f_wZ2NLH6fZx8FbSMCgBNiawMijaGrhyG07v4owo31ywZykeu9u1UySXSUCOmyPpCFbMhoYrlN0Mt6jYS6a0Qn3iEk0ibYuVsaQTDynuIf3Dau1t6qVeJFHBDOePZxZiOtz17kp69sn1ahxa50yDEAnYNQmWOTzf5lwpQz4OcEMvhDwoH38R3QxEPHmX2i8YZjiLB4dwIXGvQnTqx79IpUhZLgMr628gZ-zxzAYFGMzx1LVn-846wrkG_QTzwrmvzAWCMPLyGaQJ3HFt2UMFIEGnpgMLwgOCeWUqk46Ym2SOWQcvRwrbA4o1qgX-sbgxMKJyMlPztR___DguwEfFGLfu7aaURB9ParnlnFtXUuLkLv8dAsr_enLK4zSrpcE0fWN2sJbgM_f4lz4H9AkWUF7H5Au8wsTESGzTFIgjZDwnrH2vqdvnDyCjjMJdaMHuMTgN4GwKcSgygVrg-XuWF6lNAs9T-czpXW8axj021-LTjuWWNOw-LB878dK30Zc9x7qbKFN8x0R2RAhkZfQDYQ4OWRbmP5E1fTZH4l6sw7qHt3A_8fmSCsk4UF16VuGS0XRdmu2Gfx6gLPpHuuKI1J0nZBMhI3kHNC6PyPPX3Vwkc3epIHI21HzT0hmADNw2rHN6iEOUDl_8qQlRMKf51LGeWBLxNypEck7eP7aJ_o8B9tAfIfJ9wa4qSdVyeI--Ku-VF-8lDeN8ZyG_JINvAZwJjRxCPjzb3kSefKc4D_XR5Nq3vXUwV5G4ZjnV5Ya0SiZ09mE-LgXuZzcw85wRhx2P-fa_VKv_5' , `time` = '1555913267'
  WHERE `session_id` = '36e778e15516d62107c49e4066b55292'

20 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

1. 3 × SELECT *
  FROM j25_k2_items
2. 2 × SELECT *
  FROM j25_k2_categories
3. 1 × SELECT *
  FROM j25_k2_rating
4. 1 × SELECT *
  FROM j25_k2_attachments
5. 1 × SELECT COUNT(*)
  FROM j25_k2_comments
6. 1 × SELECT guest, usertype, client_id
  FROM j25_session
7. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM j25_modules AS m
  LEFT JOIN j25_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN j25_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
8. 1 × SELECT id
  FROM j25_k2_categories
9. 1 × SELECT b.id
  FROM j25_usergroups AS a
  LEFT JOIN j25_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
10. 1 × SELECT `session_id`
  FROM `j25_session`
11. 1 × SELECT id, rules
  FROM `j25_viewlevels
12. 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 j25_menu AS m
  LEFT JOIN j25_extensions AS e
  ON m.component_id = e.extension_id
13. 1 × SELECT b.rules
  FROM j25_assets AS a
  LEFT JOIN j25_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
14. 1 × SELECT a.rules
  FROM j25_assets AS a
15. 1 × SELECT `data`
  FROM `j25_session`

OTRAS Tablas:

1. 1 × UPDATE `j25_session`
  SET `data` = 'ib_6P3Zj-xY59uNFNw5GR7D2x9siBXVEW-pMC85xNpM2dXSmzrsgqF0mezRQpoNsZYWSpmNYLMGvQwCn8nu7ICXqh0Nubr7vvSVdk4ePjttOsz7GkcywKGDdLiokn_ODZTDASOt13Pc9VSaeXd61HWkBJyx7sJrIa60ipBSgSHNcjJ_Ni2eosBYRnavY5FXLxTFV9PUfQXPuP_4xQOo7EARCjAfF2PDZ7KXhTCqsSNTjJz8rapJLAFEGCzaZDF_mrAETj2-XfWC2zEnaGAY2nUz4YzcZ8GxcfJz46MylMrf44fo5c5jLWFjrhCLoBsfAiPLs-GMQ9iKskx5QfjAiHw6xrwIbxBqwmPJ8qpbrHCg0WMxTPMKeo0AwRC8u2qiadACqMejpfSZ-U9rUQ7oMTz0BhV2yahDZF8ae-_3GFztrCKd9rVA3CUcdRZH3LuBpRqiyoJ77FgouzQWc2ZnbCj6zL4sawT3O7BgUdm8BOOA_V5z9_WuhzNrUJVf3E9Ep9QWKn9jAQ9rnowASCq1ztH2j4dq67uoa5Bq-raX8hm1tZhS4QdkytZiX5vnFL8BieXo0XuVSR_aloXrwDogeA9BA2G0hDj-4oQ6uVkqSeRPLc1KYCDJqyCM76rZ-bVk1iPTgkD1SuzJdJLQQKr7sbBDB0IrvKLwvVyp7BcNBf_f34xKVmoL46BXrc9KD5PYtxpMXlMxSSw4CJYDLsFxsxX89CrF53KcnCMovbGogZU5zMgFlHutn8zoWjbadpkG_JN2UNFMNTtEs2tjniJChj7jyXTRef5SBCdrlsf-LA3z1HLKTU4l0bIPh20Nt3bfZkm--kvxduO57BOYp6LM8KlIGTZ2E-88f_wZ2NLH6fZx8FbSMCgBNiawMijaGrhyG07v4owo31ywZykeu9u1UySXSUCOmyPpCFbMhoYrlN0Mt6jYS6a0Qn3iEk0ibYuVsaQTDynuIf3Dau1t6qVeJFHBDOePZxZiOtz17kp69sn1ahxa50yDEAnYNQmWOTzf5lwpQz4OcEMvhDwoH38R3QxEPHmX2i8YZjiLB4dwIXGvQnTqx79IpUhZLgMr628gZ-zxzAYFGMzx1LVn-846wrkG_QTzwrmvzAWCMPLyGaQJ3HFt2UMFIEGnpgMLwgOCeWUqk46Ym2SOWQcvRwrbA4o1qgX-sbgxMKJyMlPztR___DguwEfFGLfu7aaURB9ParnlnFtXUuLkLv8dAsr_enLK4zSrpcE0fWN2sJbgM_f4lz4H9AkWUF7H5Au8wsTESGzTFIgjZDwnrH2vqdvnDyCjjMJdaMHuMTgN4GwKcSgygVrg-XuWF6lNAs9T-czpXW8axj021-LTjuWWNOw-LB878dK30Zc9x7qbKFN8x0R2RAhkZfQDYQ4OWRbmP5E1fTZH4l6sw7qHt3A_8fmSCsk4UF16VuGS0XRdmu2Gfx6gLPpHuuKI1J0nZBMhI3kHNC6PyPPX3Vwkc3epIHI21HzT0hmADNw2rHN6iEOUDl_8qQlRMKf51LGeWBLxNypEck7eP7aJ_o8B9tAfIfJ9wa4qSdVyeI--Ku-VF-8lDeN8ZyG_JINvAZwJjRxCPjzb3kSefKc4D_XR5Nq3vXUwV5G4ZjnV5Ya0SiZ09mE-LgXuZzcw85wRhx2P-fa_VKv_5' , `time` = '1555913267'
2. 1 × UPDATE j25_k2_items
  SET `hits` = (`hits` + 1)
3. 1 × SHOW FULL COLUMNS
  FROM `j25_k2_items
4. 1 × SHOW FULL COLUMNS
  FROM `j25_k2_categories
5. 1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('36e778e15516d62107c49e4066b55292', 0, '1555913266'