Consola de Joomla! Debug

78 Registro Consultas

1. SELECT `data`
  FROM `j25_session`
  WHERE `session_id` = 'b580546e640fe949450e158f4dc7b9e2'
2. DELETE
  FROM `j25_session`
  WHERE `time` < '1550515933'
3. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = 'b580546e640fe949450e158f4dc7b9e2'
  LIMIT 0, 1
4. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('b580546e640fe949450e158f4dc7b9e2', 0, '1550517733')
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. SELECT *
  FROM j25_k2_items
  WHERE id=472
  LIMIT 0, 1
12. SHOW FULL COLUMNS
  FROM `j25_k2_categories`
13. SELECT *
  FROM j25_k2_categories
  WHERE id = '76'
14. SELECT *
  FROM j25_k2_categories
  WHERE id = '126'
15. SELECT *
  FROM j25_k2_attachments
  WHERE itemID=472
16. SELECT *
  FROM j25_k2_rating
  WHERE itemID = 472
17. SELECT COUNT(*)
  FROM j25_k2_comments
  WHERE itemID=472
  AND published=1
18. SHOW FULL COLUMNS
  FROM `j25_k2_items`
19. UPDATE j25_k2_items
  SET `hits` = (`hits` + 1)
  WHERE id = '472'
20. SELECT *
  FROM j25_k2_items
  WHERE id > 472
  AND catid=76
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-18 19:22:13' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-18 19:22:13' )
  AND access IN(1,1)
  AND trash=0
  ORDER BY ordering ASC
  LIMIT 0, 1
21. SELECT *
  FROM j25_k2_items
  WHERE id < 472
  AND catid=76
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-18 19:22:13' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-18 19:22:13' )
  AND access IN(1,1)
  AND trash=0
  ORDER BY ordering DESC
  LIMIT 0, 1
22. 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 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-02-18 19:22:13' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-18 19:22:13' )
  AND i.catid IN(127,92,76,69,70,90,89,82,59,63,72,124,88,93,46,60,48,47,75,45,94,52,95,53,61,74,54,67,96,51,97,68,98,66,71,99,65,79,100,81,101,50,102,78,123,86,85,83,34,126,125,36,37,103)
  AND i.created > DATE_SUB('2019-02-18 19:22:13',INTERVAL 180 DAY)
  ORDER BY i.hits DESC
  LIMIT 0, 3
23. 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 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-02-18 19:22:13' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-18 19:22:13' )
  AND i.catid IN(127,76,83,34,126,125,36,37)
  ORDER BY i.hits DESC
  LIMIT 0, 4
24. SELECT guest, usertype, client_id
  FROM j25_session
  WHERE client_id = 0
25. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
26. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 27
  AND cl.state = 1
  AND a.catid IN (134)
  ORDER BY a.sticky DESC,a.ordering
27. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 27
  AND cl.state = 1
  AND a.catid IN (134)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
28. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
29. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 20
  AND cl.state = 1
  AND a.catid IN (129)
  ORDER BY a.sticky DESC,RAND()
30. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 20
  AND cl.state = 1
  AND a.catid IN (129)
  ORDER BY a.sticky DESC,RAND()
  LIMIT 0, 1
31. UPDATE j25_banners
  SET impmade = (impmade + 1)
  WHERE id = 28
32. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 35
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,a.ordering
34. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 35
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 5
35. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
36. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 37
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,a.ordering
37. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 37
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 5
38. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
39. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 29
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,RAND()
40. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 29
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,RAND()
  LIMIT 0, 1
41. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
42. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 31
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,RAND()
43. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 31
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,RAND()
  LIMIT 0, 1
44. UPDATE j25_banners
  SET impmade = (impmade + 1)
  WHERE id = 43
45. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
46. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 39
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,RAND()
47. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 39
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,RAND()
  LIMIT 0, 1
48. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
49. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 22
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,RAND()
50. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 22
  AND cl.state = 1
  AND a.catid IN (131)
  ORDER BY a.sticky DESC,RAND()
  LIMIT 0, 1
51. UPDATE j25_banners
  SET impmade = (impmade + 1)
  WHERE id = 31
52. 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 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-02-18 19:22:13' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-18 19:22:13' )
  AND i.catid IN(76)
  ORDER BY i.created DESC
  LIMIT 0, 3
53. 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 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-02-18 19:22:13' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-18 19:22:13' )
  AND i.catid IN(59)
  ORDER BY i.created DESC
  LIMIT 0, 2
54. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
55. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  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.catid IN (130)
  ORDER BY a.sticky DESC,a.ordering
56. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  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.catid IN (130)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 5
57. UPDATE j25_banners
  SET impmade = (impmade + 1)
  WHERE id = 30
58. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
59. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 21
  AND cl.state = 1
  AND a.catid IN (126)
  ORDER BY a.sticky DESC,a.ordering
60. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 21
  AND cl.state = 1
  AND a.catid IN (126)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
61. UPDATE j25_banners
  SET impmade = (impmade + 1)
  WHERE id = 29
62. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
63. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 23
  AND cl.state = 1
  AND a.catid IN (133)
  ORDER BY a.sticky DESC,a.ordering
64. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 23
  AND cl.state = 1
  AND a.catid IN (133)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
65. UPDATE j25_banners
  SET impmade = (impmade + 1)
  WHERE id = 36
66. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
67. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 19
  AND cl.state = 1
  AND a.catid IN (128)
  ORDER BY a.sticky DESC,a.ordering
68. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 19
  AND cl.state = 1
  AND a.catid IN (128)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
69. UPDATE j25_banners
  SET impmade = (impmade + 1)
  WHERE id = 27
70. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
71. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 18
  AND cl.state = 1
  AND a.catid IN (127)
  ORDER BY a.sticky DESC,a.ordering
72. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 18
  AND cl.state = 1
  AND a.catid IN (127)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
73. UPDATE j25_banners
  SET impmade = (impmade + 1)
  WHERE id = 26
74. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 19:22:13' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
75. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 17
  AND cl.state = 1
  AND a.catid IN (109)
  ORDER BY a.sticky DESC,a.ordering
76. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_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 = 17
  AND cl.state = 1
  AND a.catid IN (109)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
77. UPDATE j25_banners
  SET impmade = (impmade + 1)
  WHERE id = 24
78. UPDATE `j25_session`
  SET `data` = 'y2mExWhGpnl2yYiIoSICD0TF98W49DHfIZnuV7gVBGLoVHIGyqcdcPqGPjuQdQi6c8QDVQnYZCZnJi0V-Ve3c65p7yEpKi1b6KqM11l2m3injdTAmg5eI-AVN-Jr34bdFDNzuoE1AJD1TwiULmQL1XYq3OF6IQnCWf3d_IEa7n-n11-yluJFvlWo6Oi4bfyMzEc7V5YjHaxO0WcdvwIcbOLoAhMtZha6e2Ole3cSlVOubWIz2cVrJ2faLjPsrJtpnK1ki8zG5HQuydiuDfg_MmAQE211_UB-oHWLxdLSPSCpE1G2n4FFRZcWW95dbuUm3gC_29SmFyKAAZnvQPFA0kOOzT8DkHwInuVoUbacJVr5PMNfWlokfYhej6dZ81TcRnzYbGL4VDsH49adMLBOG-NqiSfZv7hWdtCDAlYSgRcVdBD4vNRLEy6n0ow5PyVc1imyatxwEDuITZ0Q5xXqv_W97ND9E489zBnM8fTtj_0DvY9wKg_KVGi98jNs_OurKFw2w1SQRNWSyF-thjg9PkZMbyJip8aa0M2PzPIZRf3risNFsKA5zcHU8Ke2yMY8LddEwRn97y_OCqqKfFOJ3G2ZmlTZGxwfVhu5W2lAJ9Vu3kE9tWGJnrPK0PWDhpfFU7WK-Zz-ynac6ACO7NyopWXVa8xPr_Dw5Ssn6qAQaF_iG6gYh4HveZ-ulutbSOr3lRPFBCtEzbZzfh2DgVJ_4a3uDCw2kflByVWAA2eYBo34XzsdkvnvA1YPvYkAarVocZVirGP35v4WKmfl0kaf2YIyJX_gxajC5xdxtZk83ef-9LLKtZhJaOcFSp8AFt6uaiAhCd5AHoJ4b4GvJNZOyNPPobA_2tNBkBeocjeHSXMQ9dUcgcN07m5GlZf_aUDa0sC1d5Btpj__wf9RgzL1ChHSU5vWgWPFYL4p2283N7uvNmuliYagwuOZkGYuIL2AEGx48wEZBHq5lCJdWTOPJdk-KrvWVXYXXj57BiBju8kQzKu1MCGS6AnepXXz_23vBitdUpe6P-ApegUxnGkUdmkRlBS9IibSuaoL3WrY4d888vDZTgMQEnnfg4gAJLRjwWIopiZXsg2ZHjovaDr1x_ain7baMveVYPqyN9wHHp5G5tvzo1F5vIdqO5_WkNn_5mQ2cv1ZBeRu4EZEt58C_YMQk5fP-eyZf_SXFHLsAhCc0eupeymBe2aMiAc5YE7bTbdquHO08AjfSIlVL_QC6Z0E3v-e8NgBIqbgZM77JBweTQfEbeb1T0RfDy24XZWhyWgFecUo2wxt7XlEdcDCcuXXx5wS5YfjC6SQhGfdQLD1R_jVhuYRYXmt8Zr5d4HwlRiDuUKbnMhbJ18B8Ljvy9ys99WbFqrXiljFtrinM5C2mVr2QnXSHDcRpMSgINpv9YO8Q6CyXYhzj3tBQOQS_BHUAu9-YqUwWMum45Ym8MtqPZlDtIJw7XcDyAA9_pqsW_6dqSQDolTH6PavNYj3Wi-jx7apYB8xlDrhe-GFl-goJaTrKeqdILfpCyd8yox6' , `time` = '1550517735'
  WHERE `session_id` = 'b580546e640fe949450e158f4dc7b9e2'

25 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

1. 26 × 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN j25_categories as cat
  ON a.catid = cat.id
2. 14 × SELECT *
  FROM j25_banners
3. 4 × 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 c
  ON c.id = i.catid
4. 3 × SELECT *
  FROM j25_k2_items
5. 2 × SELECT *
  FROM j25_k2_categories
6. 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 j25_banners as a
  LEFT JOIN j25_banner_clients AS cl
  ON cl.id = a.cid
7. 1 × SELECT guest, usertype, client_id
  FROM j25_session
8. 1 × SELECT id, rules
  FROM `j25_viewlevels
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 COUNT(*)
  FROM j25_k2_comments
12. 1 × SELECT *
  FROM j25_k2_attachments
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 id
  FROM j25_k2_categories
16. 1 × SELECT `data`
  FROM `j25_session`
17. 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
18. 1 × SELECT *
  FROM j25_k2_rating

OTRAS Tablas:

1. 9 × UPDATE j25_banners
  SET impmade = (impmade + 1)
2. 1 × UPDATE `j25_session`
  SET `data` = 'y2mExWhGpnl2yYiIoSICD0TF98W49DHfIZnuV7gVBGLoVHIGyqcdcPqGPjuQdQi6c8QDVQnYZCZnJi0V-Ve3c65p7yEpKi1b6KqM11l2m3injdTAmg5eI-AVN-Jr34bdFDNzuoE1AJD1TwiULmQL1XYq3OF6IQnCWf3d_IEa7n-n11-yluJFvlWo6Oi4bfyMzEc7V5YjHaxO0WcdvwIcbOLoAhMtZha6e2Ole3cSlVOubWIz2cVrJ2faLjPsrJtpnK1ki8zG5HQuydiuDfg_MmAQE211_UB-oHWLxdLSPSCpE1G2n4FFRZcWW95dbuUm3gC_29SmFyKAAZnvQPFA0kOOzT8DkHwInuVoUbacJVr5PMNfWlokfYhej6dZ81TcRnzYbGL4VDsH49adMLBOG-NqiSfZv7hWdtCDAlYSgRcVdBD4vNRLEy6n0ow5PyVc1imyatxwEDuITZ0Q5xXqv_W97ND9E489zBnM8fTtj_0DvY9wKg_KVGi98jNs_OurKFw2w1SQRNWSyF-thjg9PkZMbyJip8aa0M2PzPIZRf3risNFsKA5zcHU8Ke2yMY8LddEwRn97y_OCqqKfFOJ3G2ZmlTZGxwfVhu5W2lAJ9Vu3kE9tWGJnrPK0PWDhpfFU7WK-Zz-ynac6ACO7NyopWXVa8xPr_Dw5Ssn6qAQaF_iG6gYh4HveZ-ulutbSOr3lRPFBCtEzbZzfh2DgVJ_4a3uDCw2kflByVWAA2eYBo34XzsdkvnvA1YPvYkAarVocZVirGP35v4WKmfl0kaf2YIyJX_gxajC5xdxtZk83ef-9LLKtZhJaOcFSp8AFt6uaiAhCd5AHoJ4b4GvJNZOyNPPobA_2tNBkBeocjeHSXMQ9dUcgcN07m5GlZf_aUDa0sC1d5Btpj__wf9RgzL1ChHSU5vWgWPFYL4p2283N7uvNmuliYagwuOZkGYuIL2AEGx48wEZBHq5lCJdWTOPJdk-KrvWVXYXXj57BiBju8kQzKu1MCGS6AnepXXz_23vBitdUpe6P-ApegUxnGkUdmkRlBS9IibSuaoL3WrY4d888vDZTgMQEnnfg4gAJLRjwWIopiZXsg2ZHjovaDr1x_ain7baMveVYPqyN9wHHp5G5tvzo1F5vIdqO5_WkNn_5mQ2cv1ZBeRu4EZEt58C_YMQk5fP-eyZf_SXFHLsAhCc0eupeymBe2aMiAc5YE7bTbdquHO08AjfSIlVL_QC6Z0E3v-e8NgBIqbgZM77JBweTQfEbeb1T0RfDy24XZWhyWgFecUo2wxt7XlEdcDCcuXXx5wS5YfjC6SQhGfdQLD1R_jVhuYRYXmt8Zr5d4HwlRiDuUKbnMhbJ18B8Ljvy9ys99WbFqrXiljFtrinM5C2mVr2QnXSHDcRpMSgINpv9YO8Q6CyXYhzj3tBQOQS_BHUAu9-YqUwWMum45Ym8MtqPZlDtIJw7XcDyAA9_pqsW_6dqSQDolTH6PavNYj3Wi-jx7apYB8xlDrhe-GFl-goJaTrKeqdILfpCyd8yox6' , `time` = '1550517735'
3. 1 × UPDATE j25_k2_items
  SET `hits` = (`hits` + 1)
4. 1 × SHOW FULL COLUMNS
  FROM `j25_k2_items
5. 1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('b580546e640fe949450e158f4dc7b9e2', 0, '1550517733'
6. 1 × SHOW FULL COLUMNS
  FROM `j25_k2_categories
7. 1 × DELETE
  FROM `j25_session`