Hi...
queries called at the point of clicking register...
SELECT `data`
FROM `master_session`
WHERE `session_id` = 'fb2c276520f265eed21c5109ea59dfe0'
SELECT folder AS type, element AS name, params
FROM master_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT *
FROM master_languages
WHERE published=1
ORDER BY ordering ASC
SELECT extension_id AS "id", element AS "option", params, enabled
FROM master_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, 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 master_menu AS m
LEFT JOIN master_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
SELECT extension_id AS "id", element AS "option", params, enabled
FROM master_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT *
FROM `master_cbsubs_config`
WHERE `id` = '1'
SELECT a.*
FROM `master_cbsubs_plans` AS a
LEFT JOIN `master_cbsubs_plans` AS b
ON b.`id` = a.`parent`
WHERE a.published = 1
GROUP BY a.id
ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT m.`user_id`
FROM `master_cbsubs_subscriptions` AS m
WHERE m.`plan_id` = 1
AND m.`status` = 'A'
AND m.`expiry_date` < '2011-11-18 17:17:08'
AND m.`expiry_date` > '0000-00-00 00:00:00'
LIMIT 0, 10
SELECT extension_id AS "id", element AS "option", params, enabled
FROM master_extensions
WHERE `type` = 'component'
AND `element` = 'com_comprofiler'
SELECT id, home, template, s.params
FROM master_template_styles as s
LEFT JOIN master_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
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM master_comprofiler_plugin
WHERE published = 1
AND access <= 1
AND type = 'user'
ORDER BY ordering
SELECT *
FROM `master_comprofiler_plugin`
WHERE `element` = 'cbforums'
SELECT *
FROM `master_comprofiler_tabs`
WHERE `pluginid` = 533
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM master_comprofiler_plugin
WHERE published = 1
AND access <= 1
AND type = 'user/plug_cbgroupjive/plugins'
ORDER BY ordering
SELECT *
FROM `master_groupjive_plugin_auto`
WHERE ( `published` = 1 )
ORDER BY `ordering` ASC
SELECT *
FROM `master_comprofiler_plugin`
WHERE `element` = 'cbgroupjive'
SELECT *
FROM `master_comprofiler_tabs`
WHERE `pluginid` = 539
SELECT *
FROM `master_comprofiler_plugin`
WHERE `element` = 'cbblogs'
SELECT *
FROM `master_comprofiler_tabs`
WHERE `pluginid` = 529
SELECT c.*, u.*
FROM master_users AS u
LEFT JOIN master_comprofiler AS c
ON c.id = u.id
WHERE u.`username` = 'test'
LIMIT 0, 1
SELECT a.id
FROM master_user_usergroup_map AS map
LEFT JOIN master_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 46
SELECT s.*
FROM master_cbsubs_subscriptions s
WHERE s.user_id = 46
AND s.status = 'R'
ORDER BY s.plan_id
SELECT a.*
FROM `master_cbsubs_plans` AS a
WHERE a.`id` = 1
SELECT b.*
FROM master_cbsubs_payment_baskets b, master_cbsubs_payment_items i, master_cbsubs_subscriptions s
WHERE b.id = i.payment_basket_id
AND i.subscription_id = s.id
AND s.user_id = 46
AND s.plan_id = 1
AND s.id = 1
AND b.user_id = s.user_id
AND b.payment_status = 'NotInitiated'
ORDER BY b.time_initiated DESC
LIMIT 0, 1
SELECT a.*
FROM `master_cbsubs_gateway_accounts` AS a
WHERE a.enabled > 0
AND a.owner = 0
ORDER BY a.`ordering` ASC
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM master_comprofiler_plugin
WHERE published = 1
AND access <= 1
AND type = 'user/plug_cbpaidsubscriptions/plugin'
ORDER BY ordering
SELECT *
FROM `master_cbsubs_payment_items` AS m
WHERE m.`payment_basket_id` = 1
ORDER BY m.`ordering`
SELECT *
FROM `master_cbsubs_payment_totalizers` AS m
WHERE m.`payment_basket_id` = 1
ORDER BY m.`ordering`
SELECT *
FROM `master_cbsubs_subscriptions`
WHERE `id` = '1'
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM master_comprofiler_plugin
WHERE published = 1
AND access <= 1
AND type = 'user/plug_cbpaidsubscriptions/plugin/cbsubstax/validations'
ORDER BY ordering
SELECT r.*, ru.short_code AS _rule_short_code
FROM `master_cbsubs_tax_rates` AS r JOIN `master_cbsubs_tax_rules` AS ru
ON ru.id = r.`tax_rule_id`
LEFT JOIN `master_cbsubs_geo_zones` AS b
ON b.id = r.`buyer_geo_zone_id`
LEFT JOIN `master_cbsubs_geo_zones` AS s
ON s.id = r.`seller_geo_zone_id`
WHERE r.`tax_rule_id` = 1
AND ( ( r.`buyer_geo_zone_id` = 0 ) OR ( SELECT COUNT(*)
FROM `master_cbsubs_geo_zones_entries` AS be
WHERE be.geo_zone_id = b.id
AND be.`country_iso_code2` = ''
AND ( be.`province_iso_code` = '' OR be.`province_iso_code` = '' )
AND ( be.`zip_code_condition` = 0 OR ( be.`zip_code_condition` = 1
AND '' REGEXP be.`zip_code_regexp` ) OR ( be.`zip_code_condition` = 2
AND be.`zip_code_min` <= 0
AND be.`zip_code_max` >= 0 ) ) ) > 0 )
AND ( ( r.`seller_geo_zone_id` = 0 ) OR ( SELECT COUNT(*)
FROM `master_cbsubs_geo_zones_entries` AS se
WHERE se.geo_zone_id = s.id
AND se.`country_iso_code2` = 'BE'
AND ( se.`province_iso_code` = '' OR se.`province_iso_code` = 'BE-BRU' )
AND ( se.`zip_code_condition` = 0 OR ( se.`zip_code_condition` = 1
AND 'B-1050' REGEXP se.`zip_code_regexp` ) OR ( se.`zip_code_condition` = 2
AND se.`zip_code_min` <= 0
AND se.`zip_code_max` >= 0 ) ) ) > 0 )
AND ( r.`tax_outside_of_country` >= 1 )
AND r.`published` = 1
AND r.`owner` = 0
GROUP by r.`id`
ORDER by r.`priority`, r.`ordering`
SELECT a.`country_iso_code2` AS `value`, a.`country_name` AS `text`
FROM `master_comprofiler_countries` AS a
ORDER BY a.`country_name` ASC
SELECT id
FROM master_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 1
SELECT *
FROM `master_cbsubs_promotions` AS m
WHERE m.`published` = 1
ORDER BY m.`priority`, m.`ordering`
SELECT DISTINCT `position`
FROM master_modules
WHERE `client_id` = 0
AND `position` <> ''
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM master_modules AS m
LEFT JOIN master_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN master_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 <= '2011-12-02 17:17:08')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-12-02 17:17:08')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 531 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
SELECT id, home, template, params
FROM master_template_styles
WHERE client_id = 0
SELECT id, home, template, params
FROM master_template_styles
WHERE client_id = 0
SELECT id, home, template, params
FROM master_template_styles
WHERE client_id = 0
SELECT id, home, template, params
FROM master_template_styles
WHERE client_id = 0
SELECT template
FROM master_template_styles
WHERE home = 1
AND client_id = 0
SELECT extension_id AS "id", element AS "option", params, enabled
FROM master_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT id
FROM master_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access <= 1
SELECT id,language
FROM `master_menu`
WHERE home=1
SELECT m2.language, m2.id
FROM master_menu as m
LEFT JOIN master_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
LEFT JOIN master_associations as a2
ON a.key=a2.key
LEFT JOIN master_menu as m2
ON a2.id=m2.id
WHERE m.id=531
select *
FROM master_content
WHERE id =78
AND state=1
SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
FROM master_categories as c
LEFT JOIN master_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 master_categories AS cat JOIN master_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=2
AND badcats.id is null
AND (c.id=s.id OR c.language in ('en-GB','*'))
GROUP BY c.id
ORDER BY c.lft
UPDATE `master_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1322845113;s:18:\"session.timer.last\";i:1322846208;s:17:\"session.timer.now\";i:1322846228;s:22:\"session.client.browser\";s:67:\"Mozilla/5.0 (Windows NT 6.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";N;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:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;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;}}', `time` = 1322846228
WHERE `session_id` = 'fb2c276520f265eed21c5109ea59dfe0'
35 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
4 × SELECT id, home, template, params FROM master_template_styles
4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM master_extensions
4 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM master_comprofiler_plugin
3 × SELECT * FROM `master_comprofiler_tabs`
3 × SELECT * FROM `master_comprofiler_plugin`
2 × SELECT id FROM master_menu
1 × SELECT * FROM `master_cbsubs_promotions` AS m
1 × SELECT a.`country_iso_code2` AS `value`, a.`country_name` AS `text` FROM `master_comprofiler_countries` AS a
1 × SELECT r.*, ru.short_code AS _rule_short_code FROM `master_cbsubs_tax_rates` AS r JOIN `master_cbsubs_tax_rules` AS ru ON ru.id = r.`tax_rule_id` LEFT JOIN `master_cbsubs_geo_zones` AS b ON b.id = r.`buyer_geo_zone_id` LEFT JOIN `master_cbsubs_geo_zones` AS s ON s.id = r.`seller_geo_zone_id`
1 × SELECT * FROM `master_cbsubs_payment_totalizers` AS m
1 × SELECT * FROM `master_cbsubs_subscriptions`
1 × SELECT DISTINCT `position` FROM master_modules
1 × SELECT m2.language, m2.id FROM master_menu as m LEFT JOIN master_associations as a ON a.id=m.id AND a.context='com_menus.item' LEFT JOIN master_associations as a2 ON a.key=a2.key LEFT JOIN master_menu as m2 ON a2.id=m2.id
1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM master_categories as c LEFT JOIN master_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 master_categories AS cat JOIN master_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT template FROM master_template_styles
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM master_modules AS m LEFT JOIN master_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN master_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT * FROM `master_cbsubs_payment_items` AS m
1 × select * FROM master_content
1 × SELECT id,language FROM `master_menu`
1 × SELECT a.* FROM `master_cbsubs_plans` AS a
1 × SELECT a.* FROM `master_cbsubs_plans` AS a LEFT JOIN `master_cbsubs_plans` AS b ON b.`id` = a.`parent`
1 × SELECT m.`user_id` FROM `master_cbsubs_subscriptions` AS m
1 × SELECT * FROM `master_cbsubs_config`
1 × SELECT m.id, m.menutype, m.title, m.alias, 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 master_menu AS m LEFT JOIN master_extensions AS e ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params FROM master_extensions
1 × SELECT * FROM master_languages
1 × SELECT id, home, template, s.params FROM master_template_styles as s LEFT JOIN master_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT * FROM `master_groupjive_plugin_auto`
1 × SELECT `data` FROM `master_session`
1 × SELECT b.* FROM master_cbsubs_payment_baskets b, master_cbsubs_payment_items i, master_cbsubs_subscriptions s
1 × SELECT s.* FROM master_cbsubs_subscriptions s
1 × SELECT a.id FROM master_user_usergroup_map AS map LEFT JOIN master_usergroups AS a ON a.id = map.group_id
1 × SELECT c.*, u.* FROM master_users AS u LEFT JOIN master_comprofiler AS c ON c.id = u.id
1 × SELECT a.* FROM `master_cbsubs_gateway_accounts` AS a
OTHER Tables:
1 × UPDATE `master_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1322845113;s:18:\"session.timer.last\";i:1322846208;s:17:\"session.timer.now\";i:1322846228;s:22:\"session.client.browser\";s:67:\"Mozilla/5.0 (Windows NT 6.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";N;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:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;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;}}', `time` = 1322846228