Consola de Joomla! Debug

78 Registro Consultas

1. SELECT `data`
  FROM `j25_session`
  WHERE `session_id` = '1ffb49706e70dce4d5c47da840fd71f7'
2. DELETE
  FROM `j25_session`
  WHERE `time` < '1550505393'
3. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = '1ffb49706e70dce4d5c47da840fd71f7'
  LIMIT 0, 1
4. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('1ffb49706e70dce4d5c47da840fd71f7', 0, '1550507193')
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=525
  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=525
16. SELECT *
  FROM j25_k2_rating
  WHERE itemID = 525
17. SELECT COUNT(*)
  FROM j25_k2_comments
  WHERE itemID=525
  AND published=1
18. SHOW FULL COLUMNS
  FROM `j25_k2_items`
19. UPDATE j25_k2_items
  SET `hits` = (`hits` + 1)
  WHERE id = '525'
20. SELECT *
  FROM j25_k2_items
  WHERE id > 525
  AND catid=76
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-18 16:26:33' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-18 16:26:33' )
  AND access IN(1,1)
  AND trash=0
  ORDER BY ordering ASC
  LIMIT 0, 1
21. SELECT *
  FROM j25_k2_items
  WHERE id < 525
  AND catid=76
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-18 16:26:33' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-18 16:26:33' )
  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 16:26:33' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-18 16:26:33' )
  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 16:26:33',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 16:26:33' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-18 16:26:33' )
  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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-18 16:26:33' )
  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 16:26:33' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-18 16:26:33' )
  AND i.catid IN(59)
  ORDER BY i.created DESC
  LIMIT 0, 2
54. SELECT *
  FROM j25_banners
  WHERE '2019-02-18 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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 16:26:33' >= `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` = 'veH7qBCsdVWZwz4zZy22MG-lrC3YwtFzvaHpgFlSeKTkIy2LzMB5F94vZPbw_ePcCyPPX9JePhumj0qzQlyMcA7nty44EuuHSKOj4pVPyCpaARed6wDbQVwAAM_dJM6sI15Xatb-cPDohHNzn1aPPMgSCoR5TUHkHD9v8vQSuuBzn4-AVxFxomfVqF6Tg2J8z4a4gH6ekdlDw4uMEek8tGf8FIrQ-MjxIqvcZ7GWeMtleTNkipXcJkzVcVH_t8cRy3f5ig8uE2U3QpqWrRvY9IvUXlRQAm0YSCL_la371SalNZrcpyMAEGaA-lKHbCmTOPRu9dOkyPjQBWp7_UbSe-x6lgRYF6QVdOK3XoVNm_mXihXCFd780nitniGkZwwmztNxVvlgMP-vTyCitkxF4J8y1f7zx601B4EvUpmozp1O4jP9qKii4QX2hB4tNdNh2yIU47I_kAmOKHjDLZJ_iVpT1gcH2QSSkieIkz0_9kmzlamsm3mIZtOStvK0UVAQwcSngE-cfscBT-1nx7xbtG-baTCCcQlBUiI3gRa9M4mDBaxc0K05kRw2HVWMJkvMVRmb6aC4eW6WQ-Ztbe76AhorWd_8vCEaKpBc7j6Wq5qjHCf6k123N0r0DhcSXoCN5Lq8bXswp4A6iKkj7N91yST9YOd1HXTwtlXeTOWnPHcCU67ecTo2GqXuAoyNwspteO-sN1T3nAjq-36lKpObF7Xl97s8QfM0R58-ycpiXbWTNlGtIiUK939U1LvqYtM2baJ0UpB2Nw9ZZArwMYqdtnaMmaVSR2sOQxTpgf3nFt6U53wlW8TRn6V8yQaRXGjrh4cFuANuVMZUZ_yP4QclUmKLTV6_V1D1ZIe9KK0eKc61hLOZQy8lGQiaRGDPvHjKhiCGBFghBCBr-qnOPv-z6n8MHM5N40vKQd9A-DgOUXMEhPtScoZsFurz7CYCm8iwetJswnOHJUmwKrFAnFzP0qma6VeXBG6qbupxjQCbKJqe_Y-PsTHJbbaVqPeq5aPdyUGQZw8n6YpyHJgOw-NvZV5jyjHSI86DerBXc-M-VDH6WQT8LxeSNlycmvEqyhSpTjOaNT5LiP3h1vt0pTQ-M4qubnZWaU0Ji--XWU99A7bnESl0bIPBG5-Etsl9fMcyAVjQoL61Ept1W4PMQi_MHUcg9nXtFlzFM6Y5nDATca7NL_kcmyxm-qjul_aHazENH65Sao83_FYXSg8DraQTOdXGeTCg9H8WURZMBBtABYjkNruigW7FSaeegmGHmIommwvW_Xebn-v9Ru1xbfzWSUzrn-w35Nzdpx0IWWNZcWCG0d_adg8qj7qH6TptwMwlP-xXFFSNNrWf_phRUCwlEEkoP05sEsII86Dt_HWgt5FPsS8iKaYwGCyuEa5m3VjPGwYRHOCbSQtghXTWxvWmPGtG5XiW1nPe62XoCz-FeVckU_SSMN7EnBMT0tirDPQNcseZBSzDjEUNh0WQ5J7yz7ivV-Eg65xGpd3TlK9y8dI.' , `time` = '1550507200'
  WHERE `session_id` = '1ffb49706e70dce4d5c47da840fd71f7'

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` = 'veH7qBCsdVWZwz4zZy22MG-lrC3YwtFzvaHpgFlSeKTkIy2LzMB5F94vZPbw_ePcCyPPX9JePhumj0qzQlyMcA7nty44EuuHSKOj4pVPyCpaARed6wDbQVwAAM_dJM6sI15Xatb-cPDohHNzn1aPPMgSCoR5TUHkHD9v8vQSuuBzn4-AVxFxomfVqF6Tg2J8z4a4gH6ekdlDw4uMEek8tGf8FIrQ-MjxIqvcZ7GWeMtleTNkipXcJkzVcVH_t8cRy3f5ig8uE2U3QpqWrRvY9IvUXlRQAm0YSCL_la371SalNZrcpyMAEGaA-lKHbCmTOPRu9dOkyPjQBWp7_UbSe-x6lgRYF6QVdOK3XoVNm_mXihXCFd780nitniGkZwwmztNxVvlgMP-vTyCitkxF4J8y1f7zx601B4EvUpmozp1O4jP9qKii4QX2hB4tNdNh2yIU47I_kAmOKHjDLZJ_iVpT1gcH2QSSkieIkz0_9kmzlamsm3mIZtOStvK0UVAQwcSngE-cfscBT-1nx7xbtG-baTCCcQlBUiI3gRa9M4mDBaxc0K05kRw2HVWMJkvMVRmb6aC4eW6WQ-Ztbe76AhorWd_8vCEaKpBc7j6Wq5qjHCf6k123N0r0DhcSXoCN5Lq8bXswp4A6iKkj7N91yST9YOd1HXTwtlXeTOWnPHcCU67ecTo2GqXuAoyNwspteO-sN1T3nAjq-36lKpObF7Xl97s8QfM0R58-ycpiXbWTNlGtIiUK939U1LvqYtM2baJ0UpB2Nw9ZZArwMYqdtnaMmaVSR2sOQxTpgf3nFt6U53wlW8TRn6V8yQaRXGjrh4cFuANuVMZUZ_yP4QclUmKLTV6_V1D1ZIe9KK0eKc61hLOZQy8lGQiaRGDPvHjKhiCGBFghBCBr-qnOPv-z6n8MHM5N40vKQd9A-DgOUXMEhPtScoZsFurz7CYCm8iwetJswnOHJUmwKrFAnFzP0qma6VeXBG6qbupxjQCbKJqe_Y-PsTHJbbaVqPeq5aPdyUGQZw8n6YpyHJgOw-NvZV5jyjHSI86DerBXc-M-VDH6WQT8LxeSNlycmvEqyhSpTjOaNT5LiP3h1vt0pTQ-M4qubnZWaU0Ji--XWU99A7bnESl0bIPBG5-Etsl9fMcyAVjQoL61Ept1W4PMQi_MHUcg9nXtFlzFM6Y5nDATca7NL_kcmyxm-qjul_aHazENH65Sao83_FYXSg8DraQTOdXGeTCg9H8WURZMBBtABYjkNruigW7FSaeegmGHmIommwvW_Xebn-v9Ru1xbfzWSUzrn-w35Nzdpx0IWWNZcWCG0d_adg8qj7qH6TptwMwlP-xXFFSNNrWf_phRUCwlEEkoP05sEsII86Dt_HWgt5FPsS8iKaYwGCyuEa5m3VjPGwYRHOCbSQtghXTWxvWmPGtG5XiW1nPe62XoCz-FeVckU_SSMN7EnBMT0tirDPQNcseZBSzDjEUNh0WQ5J7yz7ivV-Eg65xGpd3TlK9y8dI.' , `time` = '1550507200'
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 ('1ffb49706e70dce4d5c47da840fd71f7', 0, '1550507193'
6. 1 × SHOW FULL COLUMNS
  FROM `j25_k2_categories
7. 1 × DELETE
  FROM `j25_session`