SELECT b.id
FROMxqhp_usergroupsAS a
LEFTJOINxqhp_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `xqhp_viewlevels`
SELECT a.rules
FROMxqhp_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT b.rules
FROMxqhp_assetsAS a
LEFTJOINxqhp_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_banners')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
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
FROMxqhp_menuAS m
LEFTJOINxqhp_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
SELECT `params` FROMxqhp_extensions WHERE `element`='com_sh404sef' AND `type`='component';
select `alias`,`newurl` from `xqhp_sh404sef_aliases` where `alias` = '' order by `alias` desc
SELECT `pageid` FROMxqhp_sh404sef_pageids WHERE `newurl`='index.php?option=com_content&Itemid=101&id=8&lang=ru&view=article';
SELECT* FROMxqhp_zoo_application WHERE id = 2
SELECT* FROMxqhp_zoo_category WHERE application_id = 2 AND published = 1 ORDERBY ordering
SELECT b.rules
FROMxqhp_assetsAS a
LEFTJOINxqhp_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'root.1')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT a.* FROMxqhp_zoo_itemAS a LEFTJOINxqhp_zoo_search_indexAS s ON a.id = s.item_id AND s.element_id IN ('41342a35-ff78-4f44-b27d-7592c0d9dc2d') WHERE a.type = 'portfolio' AND a.application_id = 2 AND a.access IN (1) AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-01-08 15:05:01') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-01-08 15:05:01') GROUPBY a.id ORDERBY a.priority DESC, s.value DESC LIMIT 0,1
SELECT* FROMxqhp_zoo_application WHERE id = 1
SELECT* FROMxqhp_zoo_category WHERE application_id = 1 AND published = 1 ORDERBY ordering
SELECT a.* FROMxqhp_zoo_itemAS a LEFTJOINxqhp_zoo_search_indexAS s ON a.id = s.item_id AND s.element_id IN ('725334c5-8446-44c0-bb95-7b41f3c5d79e') WHERE a.type = 'article' AND a.application_id = 1 AND a.access IN (1) AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-01-08 15:05:01') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-01-08 15:05:01') GROUPBY a.id ORDERBY a.priority DESC, s.value LIMIT 0,5
SELECT a.* FROMxqhp_zoo_itemAS a WHERE a.type = 'article' AND a.application_id = 1 AND a.access IN (1) AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-01-08 15:05:01') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-01-08 15:05:01') GROUPBY a.id ORDERBY a.priority DESC, a.created DESC LIMIT 0,5
SHOWTABLES
SELECT* FROMxqhp_languages
SELECT `id`, `title`, `alias`, `catid`, `language` FROMxqhp_content WHERE `id`=8;
SELECT* FROMxqhp_categories WHERE parent_id > 0 and extension = 'com_content' and path = 'uncategorised' and level = 1;
SHOWFULLCOLUMNS FROM `xqhp_sh404sef_metas`
SELECT* FROMxqhp_sh404sef_metas WHERE `newurl`='index.php?3de69ea13a27d1ead96ff5d7b47efae3';
UPDATE `xqhp_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1767884700;s:18:\"session.timer.last\";i:1767884700;s:17:\"session.timer.now\";i:1767884700;s:24:\"session.client.forwarded\";s:12:\"216.73.216.0\";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\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{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:10:\"superadmin\";N;}s:13:\"session.token\";s:32:\"f6a72d20480905416d32cbd812bfed18\";}'
, `time` = '1767884701'
WHERE `session_id` = 'ea996b722800388d19e61e3fca785c18'
23 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
2 × SELECT* FROMxqhp_zoo_application
2 × SELECT b.rules FROMxqhp_assetsAS a LEFTJOINxqhp_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT a.* FROMxqhp_zoo_itemAS a LEFTJOINxqhp_zoo_search_indexAS s ON a.id = s.item_id AND s.element_id IN ('725334c5-8446-44c0-bb95-7b41f3c5d79e')
1 × SELECT a.* FROMxqhp_zoo_itemAS a LEFTJOINxqhp_zoo_search_indexAS s ON a.id = s.item_id AND s.element_id IN ('41342a35-ff78-4f44-b27d-7592c0d9dc2d')
1 × SELECT `pageid` FROMxqhp_sh404sef_pageids
1 × SELECT `session_id` FROM `xqhp_session`
1 × select `alias`,`newurl` from `xqhp_sh404sef_aliases`
1 × SELECT `params` FROMxqhp_extensions
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 FROMxqhp_menuAS m LEFTJOINxqhp_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT a.rules FROMxqhp_assetsAS a
1 × SELECT id, rules FROM `xqhp_viewlevels
1 × SELECT b.id FROMxqhp_usergroupsAS a LEFTJOINxqhp_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt