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

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

1. SELECT `data`
  FROM `jos_session`
  WHERE `session_id` = 'd62c8a98280a2294f9cba322bb099c05'
2. SELECT `session_id`
  FROM `jos_session`
  WHERE `session_id` = 'd62c8a98280a2294f9cba322bb099c05'
  LIMIT 0, 1
3. INSERT INTO `jos_session` (`session_id`, `client_id`, `time`)
  VALUES ('d62c8a98280a2294f9cba322bb099c05', 0, '1591485066')
4. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jos_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
5. SELECT b.id
  FROM jos_usergroups AS a
  LEFT JOIN jos_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `jos_viewlevels`
7. SELECT folder AS type, element AS name, params
  FROM jos_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
8. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jos_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jos_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_kunena'
10. 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 jos_menu AS m
  LEFT JOIN jos_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
11. SELECT *
  FROM jos_jcomments_settings
12. SELECT id, home, template, s.params
  FROM jos_template_styles as s
  LEFT JOIN jos_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
13. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jos_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
14. SELECT *
  FROM jos_languages
  WHERE published=1
  ORDER BY ordering ASC
15. SELECT a.rules
  FROM jos_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
16. SELECT b.rules
  FROM jos_assets AS a
  LEFT JOIN jos_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
17. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM jos_categories as c
  LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=11
  AND badcats.id is null
  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id
  ORDER BY c.lft
18. SELECT b.rules
  FROM jos_assets AS a
  LEFT JOIN jos_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content.category.11')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
19. 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 jos_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 jos_content AS a
  LEFT JOIN jos_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN jos_categories AS c
  ON c.id = a.catid
  LEFT JOIN jos_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jos_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN jos_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN jos_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM jos_categories AS cat JOIN jos_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
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND a.catid = 11
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-06-06 23:11:07')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-06-06 23:11:07')
  ORDER BY c.lft,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
  LIMIT 0, 5
20. 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 jos_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 jos_content AS a
  LEFT JOIN jos_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN jos_categories AS c
  ON c.id = a.catid
  LEFT JOIN jos_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jos_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN jos_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN jos_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM jos_categories AS cat JOIN jos_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
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND a.catid = 11
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-06-06 23:11:07')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-06-06 23:11:07')
  ORDER BY c.lft,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
21. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM jos_categories as c
  LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=11
  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
22. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jos_modules AS m
  LEFT JOIN jos_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jos_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 <= '2020-06-06 23:11:07')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-06-06 23:11:07')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 101 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
23. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jos_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_phocagallery'
24. SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid
  FROM jos_phocagallery_categories AS cc
  WHERE cc.published = 1
  AND cc.access <= 0
  ORDER BY cc.ordering
25. SELECT cc.id AS idcat, a.id AS idimage
  FROM jos_phocagallery_categories AS cc
  LEFT JOIN jos_phocagallery AS a
  ON a.catid = cc.id
  WHERE a.published = 1
  AND a.approved = 1
  AND cc.published = 1
  AND cc.id IN (4)
  ORDER BY a.ordering ASC
  LIMIT 0,1
26. SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM jos_phocagallery_categories AS cc
  LEFT JOIN jos_phocagallery AS a
  ON a.catid = cc.id
  WHERE a.id in (91)
  ORDER BY a.ordering ASC
27. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jos_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_icagenda'
28. SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order
  FROM `jos_icagenda_events` AS e
  LEFT JOIN `jos_icagenda_category` AS c
  ON `c`.`id` = `e`.`catid`
  WHERE `e`.`state` = '1'
  AND `e`.`approval` = '0'
  AND e.next>=2020-06-07
  AND `e`.`access` IN (1, 1)
29. SELECT id AS idm
  FROM jos_menu
  WHERE (link = 'index.php?option=com_icagenda&view=list')
  AND (published > 0)
  AND (language = 'ru-RU')
30. SELECT id AS noidm
  FROM jos_menu
  WHERE (link = 'index.php?option=com_icagenda&view=list')
  AND (published > 0)
  AND (language = '*')
31. SELECT alias
  FROM jos_icagenda_events
  WHERE id=1
32. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jos_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_media'
33. SELECT sum(r.people) AS registered
  FROM jos_icagenda_registration AS r
  WHERE (r.eventId=1)
  AND (r.state > 0)
34. SELECT id AS idm
  FROM jos_menu
  WHERE (link = 'index.php?option=com_icagenda&view=list')
  AND (published > 0)
  AND (language = 'ru-RU')
35. SELECT id AS noidm
  FROM jos_menu
  WHERE (link = 'index.php?option=com_icagenda&view=list')
  AND (published > 0)
  AND (language = '*')
36. SELECT id AS nbevt
  FROM `jos_icagenda_events` AS e
  WHERE e.state > 0
37. SELECT guest, usertype, client_id
  FROM jos_session
  WHERE client_id = 0
38. SHOW FULL COLUMNS
  FROM `jos_assets`
39. SELECT id
  FROM jos_assets
  WHERE parent_id = 0
40. SELECT b.rules
  FROM jos_assets AS a
  LEFT JOIN jos_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
41. SELECT a.username, a.time, a.userid, a.usertype, a.client_id
  FROM jos_session AS a
  WHERE a.userid != 0
  AND a.client_id = 0
  GROUP BY a.userid
42. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jos_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_contact'
43. UPDATE `jos_session`
  SET `data` = 'joomla|s:2128:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjY6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNTkxNDg1MDY2O3M6NDoibGFzdCI7aToxNTkxNDg1MDY2O3M6Mzoibm93IjtpOjE1OTE0ODUwNjY7fXM6NToidG9rZW4iO3M6MzI6IjgyNGI1ZjQ3OTM2ZjMwYWFjZTUzNzhkZWFlNzgxOWMzIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MTA6ImNvbV9tYWlsdG8iO086ODoic3RkQ2xhc3MiOjE6e3M6NToibGlua3MiO2E6Mjp7czo0MDoiMzliMjg4OTNkOWVmMjkzYTgwM2IxNzdlYmM3NTYxNjMzZDRmZDk1OCI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo0OiJsaW5rIjtzOjE2OToiaHR0cDovL2xpYi1jaGVyLXJheW9uLnJ1OjgwODcvamlyYmlzMi9pbmRleC5waHAvMzUtaXp1Y2hlbmllLXZsaXlhbml5YS1vZ3JhbmljaGVuaWotbmEtZml6aWNoZXNrdXl1LWFrdGl2bm9zdC1uYXNlbGVuaXlhLXYtdXNsb3ZpeWFraC1zYW1vaXpvbHlhdHNpaS1wby1wcmljaGluZS1jb3ZpZC0xOSI7czo2OiJleHBpcnkiO2k6MTU5MTQ4NTA2Nzt9czo0MDoiMmE5NzJlYzYyMWRlNGZjNjZmY2ViOGZhNDI2NDMyMGMwMDI2MTEzNCI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo0OiJsaW5rIjtzOjU3OiJodHRwOi8vbGliLWNoZXItcmF5b24ucnU6ODA4Ny9qaXJiaXMyL2luZGV4LnBocC84LW5vdm9zdDEiO3M6NjoiZXhwaXJ5IjtpOjE1OTE0ODUwNjc7fX19czoyMjoiYnRsX2NhcHRjaGFfaW1hZ2VfcGF0aCI7czo2MDoiWkRZeVl6aGhPVGd5T0RCaE1qSTVOR1k1WTJKaE16SXlZbUl3T1Rsak1EVXhOVGt4TkRnMU1EWTQucG5nIjtzOjExOiJidGxfY2FwdGNoYSI7czo2OiJrWlhSS1ciO319fQ==\";' , `time` = '1591485069'
  WHERE `session_id` = 'd62c8a98280a2294f9cba322bb099c05'

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

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

1. 8 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM jos_extensions
2. 3 × SELECT b.rules
  FROM jos_assets AS a
  LEFT JOIN jos_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
3. 2 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM jos_categories as c
  LEFT JOIN jos_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 jos_categories AS cat JOIN jos_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
4. 2 × SELECT id AS idm
  FROM jos_menu
5. 2 × SELECT id AS noidm
  FROM jos_menu
6. 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 jos_contact_details AS contact
7. 1 × SELECT alias
  FROM jos_icagenda_events
8. 1 × SELECT `session_id`
  FROM `jos_session`
9. 1 × SELECT b.id
  FROM jos_usergroups AS a
  LEFT JOIN jos_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
10. 1 × SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order
  FROM `jos_icagenda_events` AS e
  LEFT JOIN `jos_icagenda_category` AS c
  ON `c`.`id` = `e`.`catid`
11. 1 × SELECT sum(r.people) AS registered
  FROM jos_icagenda_registration AS r
12. 1 × SELECT id AS nbevt
  FROM `jos_icagenda_events` AS e
13. 1 × SELECT a.username, a.time, a.userid, a.usertype, a.client_id
  FROM jos_session AS a
14. 1 × SELECT id
  FROM jos_assets
15. 1 × SELECT guest, usertype, client_id
  FROM jos_session
16. 1 × SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM jos_phocagallery_categories AS cc
  LEFT JOIN jos_phocagallery AS a
  ON a.catid = cc.id
17. 1 × SELECT cc.id AS idcat, a.id AS idimage
  FROM jos_phocagallery_categories AS cc
  LEFT JOIN jos_phocagallery AS a
  ON a.catid = cc.id
18. 1 × SELECT a.rules
  FROM jos_assets AS a
19. 1 × SELECT *
  FROM jos_languages
20. 1 × SELECT id, home, template, s.params
  FROM jos_template_styles as s
  LEFT JOIN jos_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
21. 1 × SELECT *
  FROM jos_jcomments_setting
22. 1 × SELECT folder AS type, element AS name, params
  FROM jos_extensions
23. 1 × SELECT id, rules
  FROM `jos_viewlevels
24. 1 × SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid
  FROM jos_phocagallery_categories AS cc
25. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jos_modules AS m
  LEFT JOIN jos_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jos_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
26. 1 × SELECT `data`
  FROM `jos_session`
27. 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 jos_menu AS m
  LEFT JOIN jos_extensions AS e
  ON m.component_id = e.extension_id

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

1. 1 × UPDATE `jos_session`
  SET `data` = 'joomla|s:2128:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjY6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNTkxNDg1MDY2O3M6NDoibGFzdCI7aToxNTkxNDg1MDY2O3M6Mzoibm93IjtpOjE1OTE0ODUwNjY7fXM6NToidG9rZW4iO3M6MzI6IjgyNGI1ZjQ3OTM2ZjMwYWFjZTUzNzhkZWFlNzgxOWMzIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MTA6ImNvbV9tYWlsdG8iO086ODoic3RkQ2xhc3MiOjE6e3M6NToibGlua3MiO2E6Mjp7czo0MDoiMzliMjg4OTNkOWVmMjkzYTgwM2IxNzdlYmM3NTYxNjMzZDRmZDk1OCI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo0OiJsaW5rIjtzOjE2OToiaHR0cDovL2xpYi1jaGVyLXJheW9uLnJ1OjgwODcvamlyYmlzMi9pbmRleC5waHAvMzUtaXp1Y2hlbmllLXZsaXlhbml5YS1vZ3JhbmljaGVuaWotbmEtZml6aWNoZXNrdXl1LWFrdGl2bm9zdC1uYXNlbGVuaXlhLXYtdXNsb3ZpeWFraC1zYW1vaXpvbHlhdHNpaS1wby1wcmljaGluZS1jb3ZpZC0xOSI7czo2OiJleHBpcnkiO2k6MTU5MTQ4NTA2Nzt9czo0MDoiMmE5NzJlYzYyMWRlNGZjNjZmY2ViOGZhNDI2NDMyMGMwMDI2MTEzNCI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo0OiJsaW5rIjtzOjU3OiJodHRwOi8vbGliLWNoZXItcmF5b24ucnU6ODA4Ny9qaXJiaXMyL2luZGV4LnBocC84LW5vdm9zdDEiO3M6NjoiZXhwaXJ5IjtpOjE1OTE0ODUwNjc7fX19czoyMjoiYnRsX2NhcHRjaGFfaW1hZ2VfcGF0aCI7czo2MDoiWkRZeVl6aGhPVGd5T0RCaE1qSTVOR1k1WTJKaE16SXlZbUl3T1Rsak1EVXhOVGt4TkRnMU1EWTQucG5nIjtzOjExOiJidGxfY2FwdGNoYSI7czo2OiJrWlhSS1ciO319fQ==\";' , `time` = '1591485069'
2. 1 × SHOW FULL COLUMNS
  FROM `jos_assets
3. 1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`)
  VALUES ('d62c8a98280a2294f9cba322bb099c05', 0, '1591485066'