59 queries executed

1
SELECT `data`
FROM `myext_session`
WHERE `session_id` = 'gbau89f4tset0jf9176afkpce0'2
SELECT extension_id AS id, element AS "option", params, enabled
FROM myext_extensions
WHERE `type` = 'component' AND `element` = 'com_users'3
SELECT folder AS type, element AS name, params
FROM myext_extensions
WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,5)
ORDER BY ordering4
SELECT extension_id AS id, element AS "option", params, enabled
FROM myext_extensions
WHERE `type` = 'component' AND `element` = 'com_languages'5
SELECT extension_id AS id, element AS "option", params, enabled
FROM myext_extensions
WHERE `type` = 'library' AND `element` = 'joomla'6
UPDATE `myext_extensions`
SET `params` = '{\"mediaversion\":\"f1c89eba5d9cf31ec7a38d7eb53e6702\"}'
WHERE `type` = 'library' AND `element` = 'joomla'7
SELECT `params`
 FROM `myext_comprofiler_plugin`
 WHERE `id` = 18
SELECT template
FROM myext_template_styles as s
WHERE s.client_id = 0 AND s.home = 19
SELECT template
FROM myext_template_styles as s
WHERE s.client_id = 0 AND s.home = 110
SELECT extension, file, type
FROM myext_rokcommon_configs
ORDER BY priority11
SHOW FULL COLUMNS FROM `myext_extensions`12
SELECT `extension_id`
FROM `myext_extensions`
WHERE type = 'component' AND element = 'com_roksprocket'13
SELECT *
FROM myext_extensions
WHERE `extension_id` = '10023'14
SELECT `extension_id`
FROM `myext_extensions`
WHERE type = 'module' AND element = 'mod_roksprocket'15
SELECT *
FROM myext_extensions
WHERE `extension_id` = '10023'16
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 myext_menu AS m
LEFT JOIN myext_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.lft17
SELECT *
 FROM `myext_cbsubs_config`
 WHERE `id` = 118
SELECT b.id
FROM myext_usergroups AS a
LEFT JOIN myext_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 919
SELECT id, rules
FROM `myext_viewlevels`20
SELECT a.* FROM `myext_cbsubs_plans` AS a
 LEFT JOIN `myext_cbsubs_plans` AS b ON b.`id` = a.`parent`
 WHERE a.published = 1 AND a.viewaccesslevel IN  (1, 5) 
 GROUP BY a.id
 ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` )  ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` )  ASC21
SELECT m.`user_id`
 FROM `myext_cbsubs_subscriptions` AS m
 WHERE m.`plan_id` = 1
 AND m.`status` = 'A'
 AND m.`expiry_date` < '2014-12-23 19:13:02'
 AND m.`expiry_date` > '0000-00-00 00:00:00' LIMIT 0, 1022
SELECT m.`user_id`
 FROM `myext_cbsubs_subscriptions` AS m
 WHERE m.`plan_id` = 2
 AND m.`status` = 'A'
 AND m.`expiry_date` < '2014-12-23 19:13:02'
 AND m.`expiry_date` > '0000-00-00 00:00:00' LIMIT 0, 1023
SELECT extension_id AS id, element AS "option", params, enabled
FROM myext_extensions
WHERE `type` = 'component' AND `element` = 'com_comprofiler'24
SELECT *
FROM myext_languages
WHERE published=1
ORDER BY ordering ASC25
SELECT id, home, template, s.params
FROM myext_template_styles as s
LEFT JOIN myext_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 = 126
SELECT `params`
 FROM `myext_modules`
 WHERE `module` = 'mod_cblogin'
 ORDER BY `ordering` LIMIT 0, 127
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 FROM `myext_comprofiler_plugin`
 WHERE `published` = 1
 AND `viewaccesslevel` IN (1,5)
 AND `type` = 'user'
 ORDER BY `ordering`28
SELECT *
 FROM `myext_comprofiler_plugin_autoactions`
 WHERE `published` = 1
 ORDER BY `ordering` ASC29
SHOW FULL COLUMNS FROM `myext_users`30
SELECT c.*, u.*
 FROM myext_users AS u
 LEFT JOIN myext_comprofiler AS c ON c.id = u.id
 WHERE u.`email` = 'my@mail.com'31
SELECT a.id
FROM myext_user_usergroup_map AS map
LEFT JOIN myext_usergroups AS a ON a.id = map.group_id
WHERE map.user_id = 46932
SELECT *
FROM `myext_users`
WHERE `id` = '0'33
SELECT id, password
FROM myext_users
WHERE username='df satf'34
SELECT *
FROM `myext_users`
WHERE `id` = 46935
SELECT `g`.`id`,`g`.`title`
FROM `myext_usergroups` AS g
INNER JOIN `myext_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 46936
SELECT c.*, u.*
 FROM myext_users AS u
 LEFT JOIN myext_comprofiler AS c ON c.id = u.id
 WHERE u.`id` = 46937
SELECT s.* FROM myext_cbsubs_subscriptions s
 WHERE s.user_id = 469
 AND s.status = 'A'
 ORDER BY s.plan_id38
SELECT a.* FROM `myext_cbsubs_plans` AS a
 WHERE a.`id` = 139
SELECT b.*
 FROM myext_cbsubs_payment_baskets b
 WHERE b.user_id = 469
 AND b.payment_status = 'NotInitiated'
 AND b.payment_method IS NULL
 ORDER BY b.time_initiated DESC LIMIT 0, 140
SELECT s.* FROM myext_cbsubs_subscriptions s
 WHERE s.user_id = 46941
SELECT id, password
FROM myext_users
WHERE username='df satf'42
SELECT `id`
FROM `myext_users`
WHERE `username` = 'df satf' LIMIT 0, 143
SELECT *
FROM `myext_users`
WHERE `id` = 46944
SELECT `g`.`id`,`g`.`title`
FROM `myext_usergroups` AS g
INNER JOIN `myext_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 46945
SELECT b.id
FROM myext_user_usergroup_map AS map
LEFT JOIN myext_usergroups AS a ON a.id = map.group_id
LEFT JOIN myext_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE map.user_id = 46946
SELECT a.rules
FROM myext_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft47
SHOW FULL COLUMNS FROM `myext_assets`48
SELECT id
FROM myext_assets
WHERE parent_id = 049
SELECT b.rules
FROM myext_assets AS a
LEFT JOIN myext_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.lft50
SELECT `session_id`
FROM `myext_session`
WHERE `session_id` = 'gbau89f4tset0jf9176afkpce0' LIMIT 0, 151
UPDATE `myext_session`
SET `guest` = '0'
	, `username` = 'df satf'
	, `userid` = 469
WHERE `session_id` = 'gbau89f4tset0jf9176afkpce0'52
SELECT *
FROM `myext_users`
WHERE `id` = 46953
SELECT `g`.`id`,`g`.`title`
FROM `myext_usergroups` AS g
INNER JOIN `myext_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 46954
UPDATE `myext_users`
SET `lastvisitDate`='2014-12-23 18:13:02'
WHERE `id`=46955
SELECT a.rules
FROM myext_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft56
SELECT f.* FROM myext_comprofiler_fields f
 INNER JOIN myext_comprofiler_tabs AS t ON (f.tabid = t.tabid)
 WHERE f.published = 1
 ORDER BY t.position, t.ordering, f.ordering57
SELECT * FROM myext_comprofiler_tabs t
 WHERE t.enabled=1
 AND t.viewaccesslevel IN (1,5)
 ORDER BY t.position, t.ordering58
SELECT *
 FROM `myext_comprofiler_fields`
 WHERE `fieldid` = 31359
UPDATE `myext_comprofiler`
 SET `cb_points` = '12'
 WHERE `id` = 469