Консоль отладки Joomla!

304 SQL-запросов зафиксировано

1. SELECT `data`
  FROM `j25_session`
  WHERE `session_id` = '7cd47f77babd9a309b1203b8a0bbafaf'
2. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = '7cd47f77babd9a309b1203b8a0bbafaf'
  LIMIT 0, 1
3. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('7cd47f77babd9a309b1203b8a0bbafaf', 0, '1744469878')
4. 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
5. SELECT id, rules
  FROM `j25_viewlevels`
6. SELECT `component`
  FROM `j25_tortags_components`
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_content')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
10. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
  FROM j25_categories as c
  LEFT JOIN j25_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM j25_categories AS cat JOIN j25_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
  LEFT JOIN `j25_content` AS i
  ON i.`catid` = c.id
  AND i.state = 1
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1)
  AND c.published = 1
  AND s.id=97
  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
11. 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_content.category.97')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
12. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM j25_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by) 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,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM j25_content AS a
  LEFT JOIN j25_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN j25_categories AS c
  ON c.id = a.catid
  LEFT JOIN j25_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN j25_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN j25_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN j25_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM j25_categories AS cat JOIN j25_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 a.access IN (1,1)
  AND c.access IN (1,1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND a.catid = 97
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-12 14:57:58')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-12 14:57:58')
  ORDER BY c.path, a.title DESC, a.created
  LIMIT 700, 100
13. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM j25_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by) 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,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM j25_content AS a
  LEFT JOIN j25_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN j25_categories AS c
  ON c.id = a.catid
  LEFT JOIN j25_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN j25_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN j25_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN j25_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM j25_categories AS cat JOIN j25_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 a.access IN (1,1)
  AND c.access IN (1,1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND a.catid = 97
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-12 14:57:58')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-12 14:57:58')
  ORDER BY c.path, a.title DESC, a.created
14. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM j25_categories as c
  LEFT JOIN j25_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM j25_categories AS cat JOIN j25_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=97
  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
15. SELECT `component`
  FROM `j25_tortags_components`
16. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
17. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3839
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
18. SELECT `component`
  FROM `j25_tortags_components`
19. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
20. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5873
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
21. SELECT `component`
  FROM `j25_tortags_components`
22. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
23. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3815
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
24. SELECT `component`
  FROM `j25_tortags_components`
25. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
26. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=236
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
27. SELECT `component`
  FROM `j25_tortags_components`
28. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
29. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2913
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
30. SELECT `component`
  FROM `j25_tortags_components`
31. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
32. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4638
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
33. SELECT `component`
  FROM `j25_tortags_components`
34. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
35. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1572
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
36. SELECT `component`
  FROM `j25_tortags_components`
37. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
38. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1805
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
39. SELECT `component`
  FROM `j25_tortags_components`
40. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
41. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3185
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
42. SELECT `component`
  FROM `j25_tortags_components`
43. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
44. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1797
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
45. SELECT `component`
  FROM `j25_tortags_components`
46. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
47. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3038
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
48. SELECT `component`
  FROM `j25_tortags_components`
49. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
50. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3870
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
51. SELECT `component`
  FROM `j25_tortags_components`
52. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
53. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2976
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
54. SELECT `component`
  FROM `j25_tortags_components`
55. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
56. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3132
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
57. SELECT `component`
  FROM `j25_tortags_components`
58. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
59. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4503
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
60. SELECT `component`
  FROM `j25_tortags_components`
61. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
62. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3914
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
63. SELECT `component`
  FROM `j25_tortags_components`
64. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
65. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3035
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
66. SELECT `component`
  FROM `j25_tortags_components`
67. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
68. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3822
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
69. SELECT `component`
  FROM `j25_tortags_components`
70. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
71. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3261
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
72. SELECT `component`
  FROM `j25_tortags_components`
73. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
74. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2102
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
75. SELECT `component`
  FROM `j25_tortags_components`
76. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
77. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4249
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
78. SELECT `component`
  FROM `j25_tortags_components`
79. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
80. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4205
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
81. SELECT `component`
  FROM `j25_tortags_components`
82. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
83. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1946
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
84. SELECT `component`
  FROM `j25_tortags_components`
85. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
86. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5716
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
87. SELECT `component`
  FROM `j25_tortags_components`
88. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
89. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=7024
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
90. SELECT `component`
  FROM `j25_tortags_components`
91. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
92. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4206
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
93. SELECT `component`
  FROM `j25_tortags_components`
94. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
95. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4010
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
96. SELECT `component`
  FROM `j25_tortags_components`
97. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
98. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1479
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
99. SELECT `component`
  FROM `j25_tortags_components`
100. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
101. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2524
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
102. SELECT created_by, catid
  FROM j25_content
  WHERE id = 914
103. 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_content.article.914')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
104. 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_attachments')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
105. SHOW FULL COLUMNS
  FROM `j25_assets`
106. SELECT id
  FROM j25_assets
  WHERE parent_id = 0
107. 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.id = 1)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
108. SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
  WHERE a.parent_id=914
  AND a.state = 1
  AND a.parent_type='com_content'
  AND a.parent_entity='article'
  AND a.access IN (1)
  ORDER BY created DESC
109. SELECT `component`
  FROM `j25_tortags_components`
110. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
111. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=914
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
112. SELECT created_by, catid
  FROM j25_content
  WHERE id = 1524
113. 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_content.article.1524')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
114. SELECT id
  FROM j25_assets
  WHERE parent_id = 0
115. SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
  WHERE a.parent_id=1524
  AND a.state = 1
  AND a.parent_type='com_content'
  AND a.parent_entity='article'
  AND a.access IN (1)
  ORDER BY created DESC
116. SELECT `component`
  FROM `j25_tortags_components`
117. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
118. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1524
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
119. SELECT `component`
  FROM `j25_tortags_components`
120. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
121. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3086
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
122. SELECT `component`
  FROM `j25_tortags_components`
123. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
124. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1153
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
125. SELECT `component`
  FROM `j25_tortags_components`
126. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
127. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5170
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
128. SELECT `component`
  FROM `j25_tortags_components`
129. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
130. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2158
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
131. SELECT `component`
  FROM `j25_tortags_components`
132. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
133. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1913
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
134. SELECT created_by, catid
  FROM j25_content
  WHERE id = 4969
135. 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_content.article.4969')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
136. SELECT id
  FROM j25_assets
  WHERE parent_id = 0
137. SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
  WHERE a.parent_id=4969
  AND a.state = 1
  AND a.parent_type='com_content'
  AND a.parent_entity='article'
  AND a.access IN (1)
  ORDER BY created DESC
138. SELECT `component`
  FROM `j25_tortags_components`
139. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
140. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4969
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
141. SELECT `component`
  FROM `j25_tortags_components`
142. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
143. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=283
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
144. SELECT `component`
  FROM `j25_tortags_components`
145. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
146. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5467
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
147. SELECT `component`
  FROM `j25_tortags_components`
148. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
149. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3667
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
150. SELECT `component`
  FROM `j25_tortags_components`
151. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
152. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=6608
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
153. SELECT `component`
  FROM `j25_tortags_components`
154. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
155. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3662
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
156. SELECT `component`
  FROM `j25_tortags_components`
157. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
158. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3721
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
159. SELECT created_by, catid
  FROM j25_content
  WHERE id = 3493
160. 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_content.article.3493')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
161. SELECT id
  FROM j25_assets
  WHERE parent_id = 0
162. SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
  WHERE a.parent_id=3493
  AND a.state = 1
  AND a.parent_type='com_content'
  AND a.parent_entity='article'
  AND a.access IN (1)
  ORDER BY created DESC
163. SELECT `component`
  FROM `j25_tortags_components`
164. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
165. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3493
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
166. SELECT `component`
  FROM `j25_tortags_components`
167. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
168. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2437
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
169. SELECT `component`
  FROM `j25_tortags_components`
170. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
171. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4406
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
172. SELECT `component`
  FROM `j25_tortags_components`
173. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
174. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3053
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
175. SELECT `component`
  FROM `j25_tortags_components`
176. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
177. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=6621
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
178. SELECT `component`
  FROM `j25_tortags_components`
179. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
180. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2035
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
181. SELECT `component`
  FROM `j25_tortags_components`
182. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
183. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=6588
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
184. SELECT `component`
  FROM `j25_tortags_components`
185. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
186. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4654
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
187. SELECT `component`
  FROM `j25_tortags_components`
188. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
189. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4681
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
190. SELECT `component`
  FROM `j25_tortags_components`
191. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
192. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3604
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
193. SELECT `component`
  FROM `j25_tortags_components`
194. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
195. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3446
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
196. SELECT `component`
  FROM `j25_tortags_components`
197. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
198. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5257
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
199. SELECT `component`
  FROM `j25_tortags_components`
200. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
201. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5197
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
202. SELECT created_by, catid
  FROM j25_content
  WHERE id = 4241
203. 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_content.article.4241')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
204. SELECT id
  FROM j25_assets
  WHERE parent_id = 0
205. SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
  WHERE a.parent_id=4241
  AND a.state = 1
  AND a.parent_type='com_content'
  AND a.parent_entity='article'
  AND a.access IN (1)
  ORDER BY created DESC
206. SELECT `component`
  FROM `j25_tortags_components`
207. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
208. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4241
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
209. SELECT created_by, catid
  FROM j25_content
  WHERE id = 4273
210. 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_content.article.4273')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
211. SELECT id
  FROM j25_assets
  WHERE parent_id = 0
212. SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
  WHERE a.parent_id=4273
  AND a.state = 1
  AND a.parent_type='com_content'
  AND a.parent_entity='article'
  AND a.access IN (1)
  ORDER BY created DESC
213. SELECT `component`
  FROM `j25_tortags_components`
214. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
215. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4273
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
216. SELECT `component`
  FROM `j25_tortags_components`
217. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
218. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5186
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
219. SELECT `component`
  FROM `j25_tortags_components`
220. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
221. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1804
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
222. SELECT `component`
  FROM `j25_tortags_components`
223. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
224. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4020
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
225. SELECT created_by, catid
  FROM j25_content
  WHERE id = 1775
226. 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_content.article.1775')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
227. SELECT id
  FROM j25_assets
  WHERE parent_id = 0
228. SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
  WHERE a.parent_id=1775
  AND a.state = 1
  AND a.parent_type='com_content'
  AND a.parent_entity='article'
  AND a.access IN (1)
  ORDER BY created DESC
229. SELECT `component`
  FROM `j25_tortags_components`
230. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
231. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1775
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
232. SELECT `component`
  FROM `j25_tortags_components`
233. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
234. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1517
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
235. SELECT `component`
  FROM `j25_tortags_components`
236. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
237. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5465
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
238. SELECT `component`
  FROM `j25_tortags_components`
239. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
240. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3856
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
241. SELECT `component`
  FROM `j25_tortags_components`
242. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
243. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3939
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
244. SELECT `component`
  FROM `j25_tortags_components`
245. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
246. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5236
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
247. SELECT created_by, catid
  FROM j25_content
  WHERE id = 1934
248. 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_content.article.1934')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
249. SELECT id
  FROM j25_assets
  WHERE parent_id = 0
250. SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
  WHERE a.parent_id=1934
  AND a.state = 1
  AND a.parent_type='com_content'
  AND a.parent_entity='article'
  AND a.access IN (1)
  ORDER BY created DESC
251. SELECT `component`
  FROM `j25_tortags_components`
252. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
253. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=1934
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
254. SELECT `component`
  FROM `j25_tortags_components`
255. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
256. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3403
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
257. SELECT `component`
  FROM `j25_tortags_components`
258. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
259. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3355
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
260. SELECT `component`
  FROM `j25_tortags_components`
261. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
262. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=281
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
263. SELECT `component`
  FROM `j25_tortags_components`
264. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
265. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5630
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
266. SELECT `component`
  FROM `j25_tortags_components`
267. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
268. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=5596
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
269. SELECT `component`
  FROM `j25_tortags_components`
270. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
271. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2954
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
272. SELECT `component`
  FROM `j25_tortags_components`
273. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
274. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2597
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
275. SELECT `component`
  FROM `j25_tortags_components`
276. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
277. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2900
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
278. SELECT created_by, catid
  FROM j25_content
  WHERE id = 2349
279. 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_content.article.2349')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
280. SELECT id
  FROM j25_assets
  WHERE parent_id = 0
281. SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
  WHERE a.parent_id=2349
  AND a.state = 1
  AND a.parent_type='com_content'
  AND a.parent_entity='article'
  AND a.access IN (1)
  ORDER BY created DESC
282. SELECT `component`
  FROM `j25_tortags_components`
283. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
284. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2349
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
285. SELECT `component`
  FROM `j25_tortags_components`
286. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
287. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=2421
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
288. SELECT `component`
  FROM `j25_tortags_components`
289. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
290. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=3464
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
291. SELECT `component`
  FROM `j25_tortags_components`
292. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
293. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4667
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
294. SELECT `component`
  FROM `j25_tortags_components`
295. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
296. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=4968
  AND `m`.`oid`=1
  ORDER BY `t`.`title` ASC
297. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM j25_modules AS m
  LEFT JOIN j25_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN j25_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-04-12 14:57:58')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-12 14:57:58')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 100454 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
298. SELECT `component`
  FROM `j25_tortags_components`
299. SELECT *
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
300. SELECT `id`
  FROM `j25_tortags_components`
  WHERE `component`='com_content'
301. SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
  WHERE `m`.`item_id`=97
  AND `m`.`oid`=1
302. SELECT `t`.`title`
  FROM `j25_tortags_tags` AS `t`
  ORDER BY `t`.`hits` DESC
  LIMIT 0, 200
303. 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_tortags')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
304. UPDATE `j25_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1744469878;s:18:\"session.timer.last\";i:1744469878;s:17:\"session.timer.now\";i:1744469878;s:24:\"session.client.forwarded\";s:13:\"18.217.89.171\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:15:\"com_attachments\";O:8:\"stdClass\":1:{s:11:\"current_url\";s:120:\"&return=aHR0cHM6Ly9kZXYubGF3LnNmdS1rcmFzLnJ1L2dyYWR1YXRlcy9qdXJpc3BydWRlbmNlP2NhdGlkPTYxJmlkPTk3Oi0tJnN0YXJ0PTcwMA%3D%3D\";}}}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:13:\"session.token\";s:32:\"8cfc4305be529c37d21cf39ad9d6b2d2\";}' , `time` = '1744469883'
  WHERE `session_id` = '7cd47f77babd9a309b1203b8a0bbafaf'

22 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

1. 83 × SELECT `component`
  FROM `j25_tortags_components
2. 82 × SELECT `t`.*
  FROM `j25_tortags_tags` AS `t`
  INNER JOIN `j25_tortags` AS `m`
  ON `m`.`tid`=`t`.`id`
3. 82 × SELECT `id`
  FROM `j25_tortags_components`
4. 14 × SELECT b.rules
  FROM j25_assets AS a
  LEFT JOIN j25_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
5. 9 × SELECT created_by, catid
  FROM j25_content
6. 9 × SELECT a.*, u.name as creator_name
  FROM j25_attachments AS a
  LEFT JOIN j25_users AS u
  ON u.id = a.created_by
7. 9 × SELECT id
  FROM j25_assets
8. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM j25_contact_details AS contact
9. 1 × SELECT `session_id`
  FROM `j25_session`
10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM j25_modules AS m
  LEFT JOIN j25_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN j25_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
11. 1 × SELECT *
  FROM `j25_tortags_components`
12. 1 × SELECT `t`.`title`
  FROM `j25_tortags_tags` AS `t`
13. 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
14. 1 × SELECT id, rules
  FROM `j25_viewlevels
15. 1 × SELECT `data`
  FROM `j25_session`
16. 1 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM j25_categories as c
  LEFT JOIN j25_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM j25_categories AS cat JOIN j25_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
17. 1 × SELECT a.rules
  FROM j25_assets AS a
18. 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
19. 1 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
  FROM j25_categories as c
  LEFT JOIN j25_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM j25_categories AS cat JOIN j25_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt

Прочие SQL-запросы:

1. 1 × UPDATE `j25_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1744469878;s:18:\"session.timer.last\";i:1744469878;s:17:\"session.timer.now\";i:1744469878;s:24:\"session.client.forwarded\";s:13:\"18.217.89.171\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:15:\"com_attachments\";O:8:\"stdClass\":1:{s:11:\"current_url\";s:120:\"&return=aHR0cHM6Ly9kZXYubGF3LnNmdS1rcmFzLnJ1L2dyYWR1YXRlcy9qdXJpc3BydWRlbmNlP2NhdGlkPTYxJmlkPTk3Oi0tJnN0YXJ0PTcwMA%3D%3D\";}}}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:13:\"session.token\";s:32:\"8cfc4305be529c37d21cf39ad9d6b2d2\";}' , `time` = '1744469883'
2. 1 × SHOW FULL COLUMNS
  FROM `j25_assets
3. 1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('7cd47f77babd9a309b1203b8a0bbafaf', 0, '1744469878'