When debug is turned on in the joomla configuration and I am saving changes in back end, then the following appears:
[code:1] 1.
SELECT *
FROM mijos_components
WHERE parent = 0
2.
SELECT folder AS type, element AS name, params
FROM mijos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
3.
SELECT *
FROM mijos_users AS u
LEFT JOIN mijos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 67
4.
SELECT gid
FROM mijos_users
WHERE id = 62
5.
SELECT g1.id AS group_id, g1.name
FROM mijos_core_acl_aro_groups g1
LEFT JOIN mijos_core_acl_aro_groups g2
ON g2.lft >= g1.lft
WHERE g2.id =25
ORDER BY g1.name
6.
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM mijos_comprofiler_plugin
WHERE published = 1
AND access <= 25
AND type = 'user'
ORDER BY ordering
7.
SELECT *
FROM mijos_users AS u
LEFT JOIN mijos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 67
8.
SELECT *
FROM mijos_comprofiler_tabs t
WHERE t.enabled = 1
AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)
ORDER BY t.position, t.ordering
9.
SELECT f.*
FROM mijos_comprofiler_fields f
INNER JOIN mijos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
AND t.enabled = 1
AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)
ORDER BY t.position, t.ordering, f.ordering
10.
SELECT MAX(time)
FROM mijos_session
WHERE userid = 67
AND guest = 0
11.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 54
ORDER BY ordering
12.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 58
ORDER BY ordering
13.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 61
ORDER BY ordering
14.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 62
ORDER BY ordering
15.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 63
ORDER BY ordering
16.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 65
ORDER BY ordering
17.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 66
ORDER BY ordering
18.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 86
ORDER BY ordering
19.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 68
ORDER BY ordering
20.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 69
ORDER BY ordering
21.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 70
ORDER BY ordering
22.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 73
ORDER BY ordering
23.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 79
ORDER BY ordering
24.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 82
ORDER BY ordering
25.
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM mijos_comprofiler_field_values
WHERE fieldid = 87
ORDER BY ordering
26.
SELECT template
FROM mijos_templates_menu
WHERE client_id = 1
AND menuid = 0
27.
SELECT id, title, module, position, content, showtitle, control, params
FROM mijos_modules AS m
LEFT JOIN mijos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 1
ORDER BY position, ordering
28.
SELECT a.name, a.admin_menu_link, a.admin_menu_img
FROM mijos_components AS a
INNER JOIN mijos_components AS b
ON b.id = a.parent
WHERE b.OPTION = 'com_comprofiler'
AND b.parent = 0
ORDER BY a.ordering ASC
29.
SELECT a.*, SUM(b.home) AS home
FROM mijos_menu_types AS a
LEFT JOIN mijos_menu AS b
ON b.menutype = a.menutype
GROUP BY a.id
30.
SELECT *
FROM mijos_components
WHERE `option` <> "com_frontpage"
AND `option` <> "com_media"
AND enabled = 1
ORDER BY ordering, name
31.
SELECT COUNT(*)
FROM mijos_messages
WHERE state = 0
AND user_id_to = 62
32.
SELECT COUNT( session_id )
FROM mijos_session
WHERE guest <> 1[/code:1]