Consola de Joomla! Debug

21 Registro Consultas

1. SELECT `data`
  FROM `j25_session`
  WHERE `session_id` = '36a5655d4179c775f7c4a01fbb197598'
2. DELETE
  FROM `j25_session`
  WHERE `time` < '1555911685'
3. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = '36a5655d4179c775f7c4a01fbb197598'
  LIMIT 0, 1
4. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('36a5655d4179c775f7c4a01fbb197598', 0, '1555913485')
5. 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
6. SELECT id, rules
  FROM `j25_viewlevels`
7. 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
8. SELECT a.rules
  FROM j25_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
9. 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
10. SELECT id
  FROM j25_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
11. SHOW FULL COLUMNS
  FROM `j25_k2_categories`
12. SELECT *
  FROM j25_k2_categories
  WHERE id = '78'
13. SELECT *
  FROM j25_k2_categories
  WHERE id = '45'
14. SELECT *
  FROM j25_k2_categories
  WHERE parent=78
  AND published=1
  AND trash=0
  AND access IN(1,1)
  ORDER BY id ASC
15. SELECT id
  FROM j25_k2_categories
  WHERE parent IN (78)
  AND id NOT IN (78)
  AND published=1
  AND trash=0
  AND access IN(1,1)
16. 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 j25_k2_items as i RIGHT JOIN j25_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 <= '2019-04-22 06:11:25' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-22 06:11:25' )
  AND c.id IN (78)
  ORDER BY lastChanged DESC
  LIMIT 0, 20
17. SELECT COUNT(*)
  FROM j25_k2_items as i RIGHT JOIN j25_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 <= '2019-04-22 06:11:25' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-22 06:11:25' )
  AND c.id IN (78)
18. SELECT COUNT(*)
  FROM j25_k2_comments
  WHERE itemID=497
  AND published=1
19. 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:11:25')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-04-22 06:11:25')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 302 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
20. SELECT guest, usertype, client_id
  FROM j25_session
  WHERE client_id = 0
21. UPDATE `j25_session`
  SET `data` = '93pFfgntOMOpeVU4lfCfT7tO8mOeCw4sSNBWbq4UaS_V3RnN7ud9A7gbulXbuudlSKygPgR5SjR_Vcdpg2nr610s6-XTAP318kHyumbwFDJFHvPGfpYECOAygaixJSPv2Sz9Nm5UXTR1nDqpg9jRAOjqhVgdX1sdt-jN3YKMGVUgWBHYKsEI1QgcJoDNjjwCNP9K35w3X05DszS0LCIbt_30GY7R0ltgnR96P_al5FAesdT4GaP2dfuPHEawZzRQbz_oi-nPBOf1LrofwelxQNFgbhdn3FD0p9sg96e-bYYu0qKn-Lofu5ZTRumVGwX-QvJG9XK9bPyIemvl0vtC0kbSOsvWKfqstVzRK81cg9P8aa8CiDHZ-C_uvZg9hbZjcXVlfly28lYZG4w-fiCs6ndWCVXUEBxaVKk3N_tawqkNDqhYfeO8Bm3Ln4TzNxm0dkDNWYfB8e9p-izLvC8yYS1DgG0FCrqLd7vOkOZPl8HuTjWN_kQ-qdDdXWzufbNQOD9SKIit_1j_zdgyP-OflTVBCGr8WKoJ8B6ZiKN7O1_mD26j4Vh-IE6SJHu44Afarh_GAYEfyisM1wwgAAdkWDT82wCpUPmwIxKM2UX-OTPXqdMbyZFo000WIcdVenGX4IrduDvK3ZHTh_e2Vfz7WgXDxsGj6JXbOv_ACGrIceiJsr4PzpXQZoC68K9XUzBI2IFJAzhiKAA-VH9K4gzxdm4mhP7-FmaLQpSTwCj-z8al2S_dUea26Di5fSWKQ8v3GI_Zv5pWQyQN8JkClJpPUhK-5iD_GMX6t4jkqa3-dvkW6N3dfq_DL-V1T2b4zLPj35-nW1N-nncDaNIcJTWmc36ciY3-RRt6TzAoYJTbvZhDGT69EpvpVDUhniSxwOqsp72QETgTKiZRqBIw5_nUeQq0PyGsg_pT0qif4_jQnQydhGKkCY6n141gnVMXPVhAZN4tVsiGT-LuJBf-mLUXuSgEObN0uAoxOKhZgee4765gQaDCho35FEQHjEoitM1MshLU0JiE_OERmJP-i3mcOjGquxgygTWMbnDstZUsawHBf_oUwCH6DVonfRW4-jbazMg-HA-IUQCDPFqMvxachufamjxectFB8wZUF6rbYsgGYenX145uLd6T6bwPAtR-68YYBMLxr_zHAG3p3EToRe09iuFQU3kYKWd8aXmLU77YuWIIJXXpkE3rhS5OoW8jeongY_70N_yAGoosVJYJ1CbOH3yzfVj3r3qIveaHhJQjNgJDEvf48ccVziyLukEfEOqc4y9lNwVTHfvH64qYA0R48d_7ckdpS_EfuhxKrP-a1pu2YX4R-a7f0r3UtMDV' , `time` = '1555913489'
  WHERE `session_id` = '36a5655d4179c775f7c4a01fbb197598'

19 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

1. 3 × SELECT *
  FROM j25_k2_categories
2. 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 j25_k2_items as i RIGHT JOIN j25_k2_categories AS c
  ON c.id = i.catid
3. 1 × SELECT id
  FROM j25_k2_categories
4. 1 × SELECT COUNT(*)
  FROM j25_k2_items as i RIGHT JOIN j25_k2_categories c
  ON c.id = i.catid
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` = '93pFfgntOMOpeVU4lfCfT7tO8mOeCw4sSNBWbq4UaS_V3RnN7ud9A7gbulXbuudlSKygPgR5SjR_Vcdpg2nr610s6-XTAP318kHyumbwFDJFHvPGfpYECOAygaixJSPv2Sz9Nm5UXTR1nDqpg9jRAOjqhVgdX1sdt-jN3YKMGVUgWBHYKsEI1QgcJoDNjjwCNP9K35w3X05DszS0LCIbt_30GY7R0ltgnR96P_al5FAesdT4GaP2dfuPHEawZzRQbz_oi-nPBOf1LrofwelxQNFgbhdn3FD0p9sg96e-bYYu0qKn-Lofu5ZTRumVGwX-QvJG9XK9bPyIemvl0vtC0kbSOsvWKfqstVzRK81cg9P8aa8CiDHZ-C_uvZg9hbZjcXVlfly28lYZG4w-fiCs6ndWCVXUEBxaVKk3N_tawqkNDqhYfeO8Bm3Ln4TzNxm0dkDNWYfB8e9p-izLvC8yYS1DgG0FCrqLd7vOkOZPl8HuTjWN_kQ-qdDdXWzufbNQOD9SKIit_1j_zdgyP-OflTVBCGr8WKoJ8B6ZiKN7O1_mD26j4Vh-IE6SJHu44Afarh_GAYEfyisM1wwgAAdkWDT82wCpUPmwIxKM2UX-OTPXqdMbyZFo000WIcdVenGX4IrduDvK3ZHTh_e2Vfz7WgXDxsGj6JXbOv_ACGrIceiJsr4PzpXQZoC68K9XUzBI2IFJAzhiKAA-VH9K4gzxdm4mhP7-FmaLQpSTwCj-z8al2S_dUea26Di5fSWKQ8v3GI_Zv5pWQyQN8JkClJpPUhK-5iD_GMX6t4jkqa3-dvkW6N3dfq_DL-V1T2b4zLPj35-nW1N-nncDaNIcJTWmc36ciY3-RRt6TzAoYJTbvZhDGT69EpvpVDUhniSxwOqsp72QETgTKiZRqBIw5_nUeQq0PyGsg_pT0qif4_jQnQydhGKkCY6n141gnVMXPVhAZN4tVsiGT-LuJBf-mLUXuSgEObN0uAoxOKhZgee4765gQaDCho35FEQHjEoitM1MshLU0JiE_OERmJP-i3mcOjGquxgygTWMbnDstZUsawHBf_oUwCH6DVonfRW4-jbazMg-HA-IUQCDPFqMvxachufamjxectFB8wZUF6rbYsgGYenX145uLd6T6bwPAtR-68YYBMLxr_zHAG3p3EToRe09iuFQU3kYKWd8aXmLU77YuWIIJXXpkE3rhS5OoW8jeongY_70N_yAGoosVJYJ1CbOH3yzfVj3r3qIveaHhJQjNgJDEvf48ccVziyLukEfEOqc4y9lNwVTHfvH64qYA0R48d_7ckdpS_EfuhxKrP-a1pu2YX4R-a7f0r3UtMDV' , `time` = '1555913489'
2. 1 × SHOW FULL COLUMNS
  FROM `j25_k2_categories
3. 1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('36a5655d4179c775f7c4a01fbb197598', 0, '1555913485'
4. 1 × DELETE
  FROM `j25_session`