Consola de depuración de Joomla!

27 consultas registradas

1. SELECT `data`
  FROM `juntas2_session`
  WHERE `session_id` = 'e45ecb9e26cfbbd87f4ee139cf69b47b'
2. DELETE
  FROM `juntas2_session`
  WHERE `time` < '1565815341'
3. SELECT `session_id`
  FROM `juntas2_session`
  WHERE `session_id` = 'e45ecb9e26cfbbd87f4ee139cf69b47b'
  LIMIT 0, 1
4. INSERT INTO `juntas2_session` (`session_id`, `client_id`, `time`)
  VALUES ('e45ecb9e26cfbbd87f4ee139cf69b47b', 0, '1566715341')
5. SELECT b.id
  FROM juntas2_usergroups AS a
  LEFT JOIN juntas2_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `juntas2_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 juntas2_menu AS m
  LEFT JOIN juntas2_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 email
  from juntas2_users
  where id=0
  LIMIT 1
9. SELECT id, ipaddress
  from juntas2_bfstop_whitelist
  WHERE (ipaddress='3.227.233.6'
  AND LOCATE('/', ipaddress) = 0)
10. SELECT id, ipaddress
  from juntas2_bfstop_whitelist
  WHERE ((LOCATE('/', ipaddress) != 0
  AND LOCATE('.', ipaddress) != 0
  AND (INET_ATON('3.227.233.6') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
11. SELECT id, ipaddress, crdate, duration
  FROM juntas2_bfstop_bannedip b
  WHERE (ipaddress='3.227.233.6'
  AND LOCATE('/', ipaddress) = 0)
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2019-08-25 03:42:22')
  AND NOT EXISTS (SELECT 1
  FROM juntas2_bfstop_unblock u
  WHERE b.id = u.block_id)
12. SELECT id, ipaddress, crdate, duration
  FROM juntas2_bfstop_bannedip b
  WHERE ((LOCATE('/', ipaddress) != 0
  AND LOCATE('.', ipaddress) != 0
  AND (INET_ATON('3.227.233.6') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2019-08-25 03:42:22')
  AND NOT EXISTS (SELECT 1
  FROM juntas2_bfstop_unblock u
  WHERE b.id = u.block_id)
13. SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_maps as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
  WHERE h.id=3
  ORDER BY h.title
14. SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, bub.disableanimation, bub.shadowstyle, bub.padding, bub.borderradius, bub.borderwidth, bub.bordercolor, bub.backgroundcolor, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.arrowsize, bub.arrowposition, bub.arrowstyle, bub.disableautopan, bub.hideclosebutton, bub.backgroundclassname, bub.published infobubblepublished
  FROM juntas2_zhgooglemaps_markers as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
  LEFT JOIN juntas2_zhgooglemaps_markergroups as g
  ON h.markergroup=g.id
  LEFT JOIN juntas2_zhgooglemaps_infobubbles as bub
  ON h.tabid=bub.id
  WHERE 1=1
  and h.mapid=3
  and h.published=1
  AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2019-08-25 06:42:22')
  AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2019-08-25 06:42:22')
  ORDER BY h.title
15. SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_markergroups as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
  WHERE EXISTS (SELECT 1
  FROM juntas2_zhgooglemaps_markers as m
  WHERE m.markergroup=h.id
  and m.mapid=3
  and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-08-25 06:42:22')
  and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-25 06:42:22'))
  ORDER BY h.title
16. SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_markergroups as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
  WHERE EXISTS (SELECT 1
  FROM juntas2_zhgooglemaps_markers as m
  WHERE m.markergroup=h.id
  and m.mapid=3
  and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-08-25 06:42:22')
  and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-25 06:42:22'))
  ORDER BY h.title
17. SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_routers as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
  WHERE h.published=1
  and h.mapid=3
18. SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_paths as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
  WHERE h.published=1
  and h.mapid=3
19. SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_adsences as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
  WHERE h.published=1
  and h.mapid=3
  AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2019-08-25 06:42:22')
  AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2019-08-25 06:42:22')
  ORDER BY h.title
20. SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_maptypes as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
  WHERE h.published=1
21. SELECT h.*
  FROM juntas2_zhgooglemaps_markers as h
  WHERE h.id = 7
22. SELECT h.*
  FROM juntas2_zhgooglemaps_markers as h
  WHERE h.id = 4
23. SHOW TABLES LIKE "juntas2_virtuemart_configs"
24. SELECT `config`
  FROM `juntas2_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
25. SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `juntas2_virtuemart_permgroups`
  ORDER BY `group_level`
26. SELECT *
  FROM `juntas2_menu`
  where `link` like "index.php?option=com_virtuemart%"
  and client_id=0
  and published=1
  and (language="*" or language LIKE "es-es")
27. UPDATE `juntas2_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1566715341;s:18:\"session.timer.last\";i:1566715341;s:17:\"session.timer.now\";i:1566715341;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;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\";N;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:13:\"session.token\";s:32:\"4c7d638730c269aa1bc538de4d66a410\";}' , `time` = '1566715342'
  WHERE `session_id` = 'e45ecb9e26cfbbd87f4ee139cf69b47b'

23 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

1. 2 × SELECT id, ipaddress, crdate, duration
  FROM juntas2_bfstop_bannedip b
2. 2 × SELECT id, ipaddress
  from juntas2_bfstop_whitelist
3. 2 × SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_markergroups as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
4. 2 × SELECT h.*
  FROM juntas2_zhgooglemaps_markers as h
5. 1 × SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_paths as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
6. 1 × SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_adsences as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
7. 1 × SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_maptypes as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
8. 1 × SELECT *
  FROM `juntas2_menu`
9. 1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `juntas2_virtuemart_permgroups`
10. 1 × SELECT `config`
  FROM `juntas2_virtuemart_configs`
11. 1 × SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_routers as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
12. 1 × SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, bub.disableanimation, bub.shadowstyle, bub.padding, bub.borderradius, bub.borderwidth, bub.bordercolor, bub.backgroundcolor, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.arrowsize, bub.arrowposition, bub.arrowstyle, bub.disableautopan, bub.hideclosebutton, bub.backgroundclassname, bub.published infobubblepublished
  FROM juntas2_zhgooglemaps_markers as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
  LEFT JOIN juntas2_zhgooglemaps_markergroups as g
  ON h.markergroup=g.id
  LEFT JOIN juntas2_zhgooglemaps_infobubbles as bub
  ON h.tabid=bub.id
13. 1 × SELECT b.id
  FROM juntas2_usergroups AS a
  LEFT JOIN juntas2_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
14. 1 × SELECT `session_id`
  FROM `juntas2_session`
15. 1 × SELECT id, rules
  FROM `juntas2_viewlevels
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 juntas2_menu AS m
  LEFT JOIN juntas2_extensions AS e
  ON m.component_id = e.extension_id
17. 1 × SELECT h.*, c.title as category
  FROM juntas2_zhgooglemaps_maps as h
  LEFT JOIN juntas2_categories as c
  ON h.catid=c.id
18. 1 × select email
  from juntas2_users
19. 1 × SELECT `data`
  FROM `juntas2_session`

OTRAS tablas:

1. 1 × UPDATE `juntas2_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1566715341;s:18:\"session.timer.last\";i:1566715341;s:17:\"session.timer.now\";i:1566715341;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;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\";N;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:13:\"session.token\";s:32:\"4c7d638730c269aa1bc538de4d66a410\";}' , `time` = '1566715342'
2. 1 × SHOW TABLES LIKE "juntas2_virtuemart_configs
3. 1 × INSERT INTO `juntas2_session` (`session_id`, `client_id`, `time`)
  VALUES ('e45ecb9e26cfbbd87f4ee139cf69b47b', 0, '1566715341'
4. 1 × DELETE
  FROM `juntas2_session`