35 consultas registradas

1. SELECT `data`
  FROM `eduba_session`
  WHERE `session_id` = '693b242835cee2583803e03afb2f8979'
2. SELECT `session_id`
  FROM `eduba_session`
  WHERE `session_id` = '693b242835cee2583803e03afb2f8979'
  LIMIT 0, 1
3. INSERT INTO `eduba_session` (`session_id`, `client_id`, `time`)
  VALUES ('693b242835cee2583803e03afb2f8979', 0, '1539752860')
4. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
5. SELECT b.id
  FROM eduba_usergroups AS a
  LEFT JOIN eduba_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `eduba_viewlevels`
7. SELECT folder AS type, element AS name, params
  FROM eduba_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
8. SELECT *
  FROM eduba_languages
  WHERE published=1
  ORDER BY ordering ASC
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. SELECT language,id
  FROM `eduba_menu`
  WHERE home = 1
  AND published = 1
  AND client_id = 0
11. 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 eduba_menu AS m
  LEFT JOIN eduba_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
12. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
13. SELECT id, home, template, s.params
  FROM eduba_template_styles as s
  LEFT JOIN eduba_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
14. SELECT a.rules
  FROM eduba_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
15. SELECT b.rules
  FROM eduba_assets AS a
  LEFT JOIN eduba_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
16. 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 eduba_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by
  AND (contact.language in ('es-ES','*') OR contact.language IS NULL)) 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 eduba_content AS a
  LEFT JOIN eduba_categories AS c
  on c.id = a.catid
  LEFT JOIN eduba_users AS u
  on u.id = a.created_by
  LEFT JOIN eduba_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eduba_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM eduba_categories AS cat JOIN eduba_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.language in ('es-ES','*')
  AND a.id = 704
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-17 05:07:40')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-17 05:07:40')
  AND (a.state = 1 OR a.state =2)
17. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM eduba_categories as c
  LEFT JOIN eduba_categories AS s
  ON (s.lft < c.lft
  AND s.rgt > c.rgt
  AND c.language in ('es-ES','*')) OR (s.lft >= c.lft
  AND s.rgt <= c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM eduba_categories AS cat JOIN eduba_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=79
  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
18. SELECT b.rules
  FROM eduba_assets AS a
  LEFT JOIN eduba_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content.article.704')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
19. SELECT a.id, a.language,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
  FROM eduba_content AS a
  LEFT JOIN eduba_categories AS cc
  ON cc.id = a.catid
  WHERE a.catid = 79
  AND a.state = 1
  AND a.access = 1
  AND (a.state = 1 OR a.state = -1)
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-10-17 05:07:40')
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-10-17 05:07:40')
  AND a.language in ('es-ES','*')
  ORDER BY a.created DESC
20. UPDATE eduba_content
  SET hits = hits + 1
  WHERE id = 704
21. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM eduba_modules AS m
  LEFT JOIN eduba_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN eduba_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 <= '2018-10-17 05:07:40')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-10-17 05:07:40')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 533 OR mm.menuid <= 0)
  AND m.language IN ('es-ES','*')
  ORDER BY m.position, m.ordering
22. SELECT sp.id polling_id, sp.id_template id_template, sp.date_start date_start, sp.date_end date_end, sp.showresultsduringpoll showresultsduringpoll, sp.multiple_answers multiple_answers, sp.voting_period voting_period, sp.number_answers number_answers, sp.voting_permission voting_permission, sp.answerpermission answerpermission, sp.autopublish autopublish, sp.baranimationtype baranimationtype, sp.coloranimationtype coloranimationtype, sp.reorderinganimationtype reorderinganimationtype, sp.dateformat dateformat, sp.autoopentimeline autoopentimeline, sp.autoanimate autoanimate, sp.showresultbutton showresultbutton, sp.showvotesperiod showvotesperiod, sp.stringdateformat stringdateformat, sp.votescountformat votescountformat, sp.scaledefault scaledefault, sp.showaddanswericon showaddanswericon, sp.showscaleicon showscaleicon, sp.showbackicon showbackicon, sp.showtimelineicon showtimelineicon, sp.showtimeline showtimeline, sp.showvotescountinfo showvotescountinfo, sp.poll_width poll_width, sp.pollalign pollalign, sp.addclearboth addclearboth, sp.poll_margintop poll_margintop, sp.poll_marginbottom poll_marginbottom, sp.poll_marginleft poll_marginleft, sp.poll_marginright poll_marginright, sp.classsuffix classsuffix, sp.checktoken checktoken, sp.ipcount ipcount, sp.checkacl checkacl, sp.votechecks votechecks, st.styles styles, sp.name polling_name, sp.question polling_question, sa.id answer_id, sa.show_name show_name, sa.img_name img_name, sa.img_url img_url, sa.img_width img_width, sa.embed embed, sa.name answer_name
  FROM `eduba_sexy_polls` sp JOIN `eduba_sexy_answers` sa
  ON sa.id_poll = sp.id
  AND sa.published = '1'
  LEFT JOIN `eduba_sexy_templates` st
  ON st.id = sp.id_template
  WHERE sp.published = '1'
  AND sp.id = 1
  ORDER BY sp.ordering,sp.name,sa.ordering,sa.name
23. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '2'
24. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '2'
25. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '1'
26. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '1'
27. SELECT sv.`ip`,sv.`date`
  FROM eduba_sexy_votes sv JOIN eduba_sexy_answers sa
  ON sa.id_poll = '1'
  WHERE sv.id_answer = sa.id
  AND sv.ip = '54.80.188.87'
  ORDER BY sv.`date` DESC
  LIMIT 1
28. SELECT sv.`ip`,sv.`date`
  FROM eduba_sexy_votes sv JOIN eduba_sexy_answers sa
  ON sa.id_poll = '1'
  WHERE sv.id_answer = sa.id
  AND sv.ip = '54.80.188.87'
  ORDER BY sv.`date` DESC
  LIMIT 1
29. SELECT COUNT(sv.`id_answer`) total_count, MAX(sv.`date`) max_date,MIN(sv.`date`) min_date
  FROM `eduba_sexy_votes` sv JOIN `eduba_sexy_answers` sa
  ON sa.id_poll = '1'
  WHERE sv.id_answer = sa.id
30. SELECT *
  FROM eduba_banners
  WHERE '2018-10-17 05:07:40' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
31. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_banners'
32. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM eduba_banners as a
  LEFT JOIN eduba_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN eduba_categories as cat
  ON a.catid = cat.id
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.cid = 2
  AND cl.state = 1
  AND a.catid IN (15)
  AND ((a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Eduba',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Eduba',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Eduba[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Eduba[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Eduba[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Eduba Barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Eduba Barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('eduba barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('eduba barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('EDUBA',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('EDUBA',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]EDUBA[[:>:]]' OR cl.metakey REGEXP '[[:<:]]EDUBA[[:>:]]' OR cat.metakey REGEXP '[[:<:]]EDUBA[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('empresa de desarrollo urbano de barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('empresa de desarrollo urbano de barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]'))
  AND a.language in ('es-ES','*')
  ORDER BY a.sticky DESC,a.ordering
33. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM eduba_banners as a
  LEFT JOIN eduba_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN eduba_categories as cat
  ON a.catid = cat.id
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.cid = 2
  AND cl.state = 1
  AND a.catid IN (15)
  AND ((a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Eduba',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Eduba',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Eduba[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Eduba[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Eduba[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Eduba Barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Eduba Barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('eduba barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('eduba barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('EDUBA',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('EDUBA',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]EDUBA[[:>:]]' OR cl.metakey REGEXP '[[:<:]]EDUBA[[:>:]]' OR cat.metakey REGEXP '[[:<:]]EDUBA[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('empresa de desarrollo urbano de barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('empresa de desarrollo urbano de barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]'))
  AND a.language in ('es-ES','*')
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
34. SELECT m2.language, m2.id
  FROM eduba_menu as m
  INNER JOIN eduba_associations as a
  ON a.id=m.id
  AND a.context='com_menus.item'
  INNER JOIN eduba_associations as a2
  ON a.key=a2.key
  INNER JOIN eduba_menu as m2
  ON a2.id=m2.id
  WHERE m.id=533
35. UPDATE `eduba_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1539752860;s:18:\"session.timer.last\";i:1539752860;s:17:\"session.timer.now\";i:1539752860;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\";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:16:\"com_mailto.links\";a:1:{s:40:\"f633e44401451ca3cea16e463daecc233f202fe1\";O:8:\"stdClass\":2:{s:4:\"link\";s:100:\"http://eduba.gov.co/index.php?option=com_content&view=article&id=704:ptl&catid=79&Itemid=533&lang=es\";s:6:\"expiry\";i:1539752860;}}s:13:\"session.token\";s:32:\"0b2db66a1f4a365deff7a597468f712e\";}' , `time` = '1539752861'
  WHERE `session_id` = '693b242835cee2583803e03afb2f8979'

26 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

1. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
2. 4 × SELECT `rules`
  FROM eduba_viewlevels
3. 2 × SELECT sv.`ip`,sv.`date`
  FROM eduba_sexy_votes sv JOIN eduba_sexy_answers sa
  ON sa.id_poll = '1'
4. 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM eduba_banners as a
  LEFT JOIN eduba_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN eduba_categories as cat
  ON a.catid = cat.id
5. 2 × SELECT b.rules
  FROM eduba_assets AS a
  LEFT JOIN eduba_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
6. 1 × SELECT id, rules
  FROM `eduba_viewlevels
7. 1 × SELECT sp.id polling_id, sp.id_template id_template, sp.date_start date_start, sp.date_end date_end, sp.showresultsduringpoll showresultsduringpoll, sp.multiple_answers multiple_answers, sp.voting_period voting_period, sp.number_answers number_answers, sp.voting_permission voting_permission, sp.answerpermission answerpermission, sp.autopublish autopublish, sp.baranimationtype baranimationtype, sp.coloranimationtype coloranimationtype, sp.reorderinganimationtype reorderinganimationtype, sp.dateformat dateformat, sp.autoopentimeline autoopentimeline, sp.autoanimate autoanimate, sp.showresultbutton showresultbutton, sp.showvotesperiod showvotesperiod, sp.stringdateformat stringdateformat, sp.votescountformat votescountformat, sp.scaledefault scaledefault, sp.showaddanswericon showaddanswericon, sp.showscaleicon showscaleicon, sp.showbackicon showbackicon, sp.showtimelineicon showtimelineicon, sp.showtimeline showtimeline, sp.showvotescountinfo showvotescountinfo, sp.poll_width poll_width, sp.pollalign pollalign, sp.addclearboth addclearboth, sp.poll_margintop poll_margintop, sp.poll_marginbottom poll_marginbottom, sp.poll_marginleft poll_marginleft, sp.poll_marginright poll_marginright, sp.classsuffix classsuffix, sp.checktoken checktoken, sp.ipcount ipcount, sp.checkacl checkacl, sp.votechecks votechecks, st.styles styles, sp.name polling_name, sp.question polling_question, sa.id answer_id, sa.show_name show_name, sa.img_name img_name, sa.img_url img_url, sa.img_width img_width, sa.embed embed, sa.name answer_name
  FROM `eduba_sexy_polls` sp JOIN `eduba_sexy_answers` sa
  ON sa.id_poll = sp.id
  AND sa.published = '1'
  LEFT JOIN `eduba_sexy_templates` st
  ON st.id = sp.id_template
8. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM eduba_modules AS m
  LEFT JOIN eduba_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN eduba_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
9. 1 × SELECT b.id
  FROM eduba_usergroups AS a
  LEFT JOIN eduba_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
10. 1 × SELECT COUNT(sv.`id_answer`) total_count, MAX(sv.`date`) max_date,MIN(sv.`date`) min_date
  FROM `eduba_sexy_votes` sv JOIN `eduba_sexy_answers` sa
  ON sa.id_poll = '1'
11. 1 × SELECT m2.language, m2.id
  FROM eduba_menu as m
  INNER JOIN eduba_associations as a
  ON a.id=m.id
  AND a.context='com_menus.item'
  INNER JOIN eduba_associations as a2
  ON a.key=a2.key
  INNER JOIN eduba_menu as m2
  ON a2.id=m2.id
12. 1 × SELECT `session_id`
  FROM `eduba_session`
13. 1 × SELECT *
  FROM eduba_banners
14. 1 × SELECT a.id, a.language,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
  FROM eduba_content AS a
  LEFT JOIN eduba_categories AS cc
  ON cc.id = a.catid
15. 1 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM eduba_categories as c
  LEFT JOIN eduba_categories AS s
  ON (s.lft < c.lft
  AND s.rgt > c.rgt
  AND c.language in ('es-ES','*')) OR (s.lft >= c.lft
  AND s.rgt <= c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM eduba_categories AS cat JOIN eduba_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
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 eduba_menu AS m
  LEFT JOIN eduba_extensions AS e
  ON m.component_id = e.extension_id
17. 1 × SELECT language,id
  FROM `eduba_menu`
18. 1 × SELECT *
  FROM eduba_languages
19. 1 × SELECT id, home, template, s.params
  FROM eduba_template_styles as s
  LEFT JOIN eduba_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
20. 1 × SELECT a.rules
  FROM eduba_assets AS a
21. 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 eduba_contact_details AS contact
22. 1 × SELECT `data`
  FROM `eduba_session`
23. 1 × SELECT folder AS type, element AS name, params
  FROM eduba_extensions

OTRAS tablas:

1. 1 × UPDATE `eduba_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1539752860;s:18:\"session.timer.last\";i:1539752860;s:17:\"session.timer.now\";i:1539752860;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\";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:16:\"com_mailto.links\";a:1:{s:40:\"f633e44401451ca3cea16e463daecc233f202fe1\";O:8:\"stdClass\":2:{s:4:\"link\";s:100:\"http://eduba.gov.co/index.php?option=com_content&view=article&id=704:ptl&catid=79&Itemid=533&lang=es\";s:6:\"expiry\";i:1539752860;}}s:13:\"session.token\";s:32:\"0b2db66a1f4a365deff7a597468f712e\";}' , `time` = '1539752861'
2. 1 × UPDATE eduba_content
  SET hits = hits + 1
3. 1 × INSERT INTO `eduba_session` (`session_id`, `client_id`, `time`)
  VALUES ('693b242835cee2583803e03afb2f8979', 0, '1539752860'