SELECT `data` 
  FROM `jos_session` 
  WHERE `session_id` = '50ec9e71c9b7dd9788a6d2425a3ef55e'
DELETE 
  FROM `jos_session` 
  WHERE `time` < 1301344543
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
SELECT extension_id AS "id", element AS "option", params, enabled 
  FROM jos_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.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,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 
  AND m.access IN (1,1) 
  ORDER BY m.lft
SELECT extension_id AS "id", element AS "option", params, enabled 
  FROM jos_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_hikashop'
SELECT * 
  FROM jos_languages 
  WHERE published=1
SELECT id, home, template, params 
  FROM jos_template_styles 
  WHERE client_id = 0
SELECT * 
  FROM jos_hikashop_config
SELECT a.* 
  FROM jos_hikashop_cart AS a 
  WHERE a.cart_id = 11 
  ORDER BY a.cart_modified DESC 
  LIMIT 1
SELECT b.*,c.* 
  FROM jos_hikashop_cart_product AS b 
  LEFT JOIN jos_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 11 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT b.*,c.* 
  FROM jos_hikashop_cart_product AS b 
  LEFT JOIN jos_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 11 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
UPDATE `jos_hikashop_cart` 
  SET `session_id`='50ec9e71c9b7dd9788a6d2425a3ef55e',`cart_modified`='1301345443' 
  WHERE cart_id='11'
SELECT id, password 
  FROM jos_users 
  WHERE username='NaturalChaos'
SHOW FIELDS 
  FROM jos_users
SELECT * 
  FROM jos_users 
  WHERE id = 42
SELECT g.id, g.title 
  FROM jos_usergroups AS g JOIN jos_user_usergroup_map AS m 
  ON m.group_id = g.id 
  WHERE m.user_id = 42
SELECT id 
  FROM jos_users 
  WHERE username = 'NaturalChaos' 
  LIMIT 0, 1
SELECT * 
  FROM jos_users 
  WHERE id = 42
SELECT g.id, g.title 
  FROM jos_usergroups AS g JOIN jos_user_usergroup_map AS m 
  ON m.group_id = g.id 
  WHERE m.user_id = 42
SELECT `session_id` 
  FROM `jos_session` 
  WHERE `session_id` = '50ec9e71c9b7dd9788a6d2425a3ef55e' 
  LIMIT 0, 1
UPDATE `jos_session` 
  SET `guest` = '0',	`username` = 'NaturalChaos',	`userid` = 42 
  WHERE `session_id` = '50ec9e71c9b7dd9788a6d2425a3ef55e'
SELECT * 
  FROM jos_users 
  WHERE id = 42
SELECT g.id, g.title 
  FROM jos_usergroups AS g JOIN jos_user_usergroup_map AS m 
  ON m.group_id = g.id 
  WHERE m.user_id = 42
UPDATE `jos_users` 
  SET `lastvisitDate` = '2011-03-28 20:50:47' 
  WHERE `id` = 42
SELECT a.*,b.* 
  FROM jos_hikashop_user AS a 
  LEFT JOIN jos_users AS b 
  ON a.user_cms_id=b.id 
  WHERE a.user_cms_id=42
SELECT a.*,b.* 
  FROM jos_hikashop_user AS a 
  LEFT JOIN jos_users AS b 
  ON a.user_cms_id=b.id 
  WHERE a.user_id=1
SELECT address_id 
  FROM jos_hikashop_address 
  WHERE address_published=1 
  AND address_user_id=1
SELECT currency_id 
  FROM jos_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 2
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT * 
  FROM jos_hikashop_zone 
  WHERE zone_namekey = 'state_New_York_4296' 
  LIMIT 1
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT b.*,c.* 
  FROM jos_hikashop_cart_product AS b 
  LEFT JOIN jos_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 11 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM jos_hikashop_file 
  WHERE file_ref_id IN (2) 
  AND file_type = 'product'
SELECT a.*,b.* 
  FROM jos_hikashop_variant AS a 
  LEFT JOIN jos_hikashop_characteristic AS b 
  ON a.variant_characteristic_id=b.characteristic_id 
  WHERE a.variant_product_id IN (2) 
  ORDER BY a.ordering,b.characteristic_value
SELECT * 
  FROM jos_hikashop_price 
  WHERE price_currency_id IN (2) 
  AND price_product_id IN (2) 
  ORDER BY price_value DESC
SELECT * 
  FROM jos_hikashop_currency 
  WHERE currency_id IN (2)
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT b.*,c.* 
  FROM jos_hikashop_category AS a 
  LEFT JOIN jos_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN jos_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey 
  WHERE a.category_id = 15 
  AND b.taxation_published=1 
  AND ( taxation_type = '' OR taxation_type = 'individual' )
SELECT * 
  FROM jos_hikashop_zone 
  WHERE zone_id = 4313
SELECT * 
  FROM jos_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND ( discount_quota>discount_used_times OR discount_quota=0 ) 
  AND discount_start < 1301345447 
  AND ( discount_end > 1301345447 OR discount_end = 0 ) 
  AND ( discount_product_id IN (2) OR discount_product_id=0 ) 
  AND discount_zone_id IN (0,4313) 
  AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT * 
  FROM jos_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='address' 
  ORDER BY a.`field_ordering` ASC
SELECT a.* 
  FROM jos_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('state_New_York_4296','country_United_States_of_America_223');
SELECT a.* 
  FROM jos_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('country_United_States_of_America_223');
SELECT * 
  FROM jos_hikashop_shipping 
  ORDER BY shipping_ordering ASC
SELECT * 
  FROM jos_hikashop_payment
SELECT * 
  FROM jos_extensions 
  WHERE element IN ('paypal') 
  AND folder='hikashoppayment' 
  AND type='plugin' 
  ORDER BY ordering ASC
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT b.*,c.* 
  FROM jos_hikashop_cart_product AS b 
  LEFT JOIN jos_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 11 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM jos_hikashop_file 
  WHERE file_ref_id IN (2) 
  AND file_type = 'product'
SELECT a.*,b.* 
  FROM jos_hikashop_variant AS a 
  LEFT JOIN jos_hikashop_characteristic AS b 
  ON a.variant_characteristic_id=b.characteristic_id 
  WHERE a.variant_product_id IN (2) 
  ORDER BY a.ordering,b.characteristic_value
SELECT * 
  FROM jos_hikashop_price 
  WHERE price_currency_id IN (2) 
  AND price_product_id IN (2) 
  ORDER BY price_value DESC
SELECT * 
  FROM jos_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND ( discount_quota>discount_used_times OR discount_quota=0 ) 
  AND discount_start < 1301345447 
  AND ( discount_end > 1301345447 OR discount_end = 0 ) 
  AND ( discount_product_id IN (2) OR discount_product_id=0 ) 
  AND discount_zone_id IN (0,4313) 
  AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT a.* 
  FROM jos_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('state_New_York_4296','country_United_States_of_America_223');
SELECT a.* 
  FROM jos_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('country_United_States_of_America_223');
SELECT * 
  FROM jos_menu 
  WHERE id = '485' 
  LIMIT 1
SELECT * 
  FROM jos_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_namekey!='address_name' 
  AND a.field_table='user' 
  ORDER BY a.`field_ordering` ASC
SELECT a.* 
  FROM jos_hikashop_zone AS a 
  WHERE a.zone_type IN ('country') 
  AND a.zone_published=1 
  ORDER BY a.zone_name_english ASC
SELECT a.* 
  FROM jos_hikashop_address AS a 
  WHERE a.address_user_id=1 
  and a.address_published=1 
  ORDER BY a.address_id DESC
SELECT * 
  FROM jos_hikashop_zone 
  WHERE zone_namekey IN ('state_New_York_4296','country_United_States_of_America_223');
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT b.*,c.* 
  FROM jos_hikashop_cart_product AS b 
  LEFT JOIN jos_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 11 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM jos_hikashop_file 
  WHERE file_ref_id IN (2) 
  AND file_type = 'product'
SELECT a.*,b.* 
  FROM jos_hikashop_variant AS a 
  LEFT JOIN jos_hikashop_characteristic AS b 
  ON a.variant_characteristic_id=b.characteristic_id 
  WHERE a.variant_product_id IN (2) 
  ORDER BY a.ordering,b.characteristic_value
SELECT * 
  FROM jos_hikashop_price 
  WHERE price_currency_id IN (2) 
  AND price_product_id IN (2) 
  ORDER BY price_value DESC
SELECT * 
  FROM jos_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND ( discount_quota>discount_used_times OR discount_quota=0 ) 
  AND discount_start < 1301345448 
  AND ( discount_end > 1301345448 OR discount_end = 0 ) 
  AND ( discount_product_id IN (2) OR discount_product_id=0 ) 
  AND discount_zone_id IN (0,4313) 
  AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT a.* 
  FROM jos_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('state_New_York_4296','country_United_States_of_America_223');
SELECT a.* 
  FROM jos_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('country_United_States_of_America_223');
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT b.id 
  FROM jos_user_usergroup_map AS map 
  LEFT JOIN jos_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN jos_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt 
  WHERE map.user_id = 42
SELECT id, rules 
  FROM `jos_viewlevels`
SELECT id, title, module, position, content, showtitle, params, mm.menuid 
  FROM jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  WHERE m.published = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-03-28 20:50:48') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-03-28 20:50:48') 
  AND m.access IN (1,1,2,3) 
  AND m.client_id = 0 
  AND (mm.menuid = 485 OR mm.menuid <= 0) 
  ORDER BY position, ordering
SELECT extension_id AS "id", element AS "option", params, enabled 
  FROM jos_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_contact'
SELECT extension_id AS "id", element AS "option", params, enabled 
  FROM jos_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_content'
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT category_id 
  FROM jos_hikashop_category 
  WHERE category_type='product' 
  AND category_id IN (2)
SELECT DISTINCT b.product_id 
  FROM jos_hikashop_product_category AS a 
  LEFT JOIN jos_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE b.product_published=1 
  AND b.product_type = 'main' 
  AND a.category_id IN (2)
SELECT DISTINCT b.* 
  FROM jos_hikashop_product_category AS a 
  LEFT JOIN jos_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE b.product_id = 0 
  LIMIT 0, 24
SELECT count( DISTINCT b.product_id) 
  FROM jos_hikashop_product_category AS a 
  LEFT JOIN jos_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE b.product_id = 0
SELECT * 
  FROM jos_hikashop_address 
  WHERE address_id = '2' 
  LIMIT 1
SELECT b.*,c.* 
  FROM jos_hikashop_cart_product AS b 
  LEFT JOIN jos_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 11 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM jos_hikashop_price 
  WHERE price_currency_id IN (2) 
  AND price_product_id IN (2) 
  ORDER BY price_value DESC
SELECT * 
  FROM jos_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND ( discount_quota>discount_used_times OR discount_quota=0 ) 
  AND discount_start < 1301345448 
  AND ( discount_end > 1301345448 OR discount_end = 0 ) 
  AND ( discount_product_id IN (2) OR discount_product_id=0 ) 
  AND discount_zone_id IN (0,4313) 
  AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
UPDATE `jos_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1301345410;s:18:\"session.timer.last\";i:1301345414;s:17:\"session.timer.now\";i:1301345443;s:24:\"session.client.forwarded\";s:12:\"65.198.37.62\";s:22:\"session.client.browser\";s:120:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.204 Safari/534.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":12:{s:7:\"cart_id\";i:11;s:11:\"currency_id\";i:2;s:7:\"zone_id\";s:4:\"4313\";s:15:\"shipping_method\";s:6:\"manual\";s:11:\"shipping_id\";i:4;s:13:\"shipping_data\";O:8:\"stdClass\":16:{s:11:\"shipping_id\";s:1:\"4\";s:13:\"shipping_type\";s:6:\"manual\";s:21:\"shipping_zone_namekey\";s:36:\"country_United_States_of_America_223\";s:15:\"shipping_tax_id\";s:2:\"15\";s:14:\"shipping_price\";s:7:\"0.00000\";s:20:\"shipping_currency_id\";s:1:\"2\";s:13:\"shipping_name\";s:13:\"Free Shipping\";s:20:\"shipping_description\";s:35:\"<p>Free shipping 
  on all orders!</p>\";s:18:\"shipping_published\";s:1:\"1\";s:17:\"shipping_ordering\";s:1:\"3\";s:15:\"shipping_params\";O:8:\"stdClass\":9:{s:19:\"shipping_percentage\";s:1:\"0\";s:18:\"shipping_min_price\";s:0:\"\";s:18:\"shipping_max_price\";s:0:\"\";s:19:\"shipping_min_weight\";s:0:\"\";s:19:\"shipping_max_weight\";s:0:\"\";s:20:\"shipping_weight_unit\";s:2:\"oz\";s:19:\"shipping_min_volume\";s:0:\"\";s:19:\"shipping_max_volume\";s:0:\"\";s:18:\"shipping_size_unit\";s:2:\"in\";}s:15:\"shipping_images\";s:4:\"usps\";s:15:\"shipping_access\";s:3:\"all\";s:23:\"shipping_price_with_tax\";d:0;s:28:\"shipping_price_orig_with_tax\";d:0;s:5:\"total\";O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":7:{s:28:\"price_value_without_discount\";d:0;s:11:\"price_value\";d:34.9500000000000028421709430404007434844970703125;s:37:\"price_value_without_discount_with_tax\";d:0;s:20:\"price_value_with_tax\";d:37.219999999999998863131622783839702606201171875;s:17:\"price_currency_id\";i:2;s:37:\"price_value_without_shipping_with_tax\";d:37.219999999999998863131622783839702606201171875;s:28:\"price_value_without_shipping\";d:34.9500000000000028421709430404007434844970703125;}}}}s:14:\"payment_method\";s:6:\"paypal\";s:10:\"payment_id\";i:1;s:12:\"payment_data\";O:8:\"stdClass\":25:{s:10:\"payment_id\";s:1:\"1\";s:12:\"payment_name\";s:6:\"PayPal\";s:19:\"payment_description\";s:69:\"<p>You can pay by credit card or paypal using this payment method</p>\";s:14:\"payment_images\";s:6:\"PayPal\";s:14:\"payment_params\";O:8:\"stdClass\":12:{s:3:\"url\";s:37:\"https://www.paypal.com/cgi-bin/webscr\";s:5:\"email\";s:22:\"naturalchaos@gmail.com\";s:12:\"address_type\";s:8:\"shipping\";s:12:\"notification\";s:1:\"1\";s:5:\"debug\";s:1:\"0\";s:10:\"cancel_url\";s:0:\"\";s:10:\"return_url\";s:0:\"\";s:16:\"cpp_header_image\";s:5:\"98034\";s:3:\"ips\";a:4:{i:0;s:12:\"66.211.169.*\";i:1;s:10:\"64.4.241.*\";i:2;s:12:\"66.211.170.*\";i:3;s:13:\"216.113.191.*\";}s:14:\"invalid_status\";s:9:\"cancelled\";s:14:\"pending_status\";s:7:\"created\";s:15:\"verified_status\";s:9:\"confirmed\";}s:12:\"payment_type\";s:6:\"paypal\";s:20:\"payment_zone_namekey\";s:36:\"country_United_States_of_America_223\";s:14:\"payment_access\";s:3:\"all\";s:12:\"extension_id\";s:5:\"10015\";s:4:\"name\";s:30:\"HikaShop Paypal payment plugin\";s:4:\"type\";s:6:\"plugin\";s:7:\"element\";s:6:\"paypal\";s:6:\"folder\";s:15:\"hikashoppayment\";s:9:\"client_id\";s:1:\"0\";s:7:\"enabled\";s:1:\"1\";s:6:\"access\";s:1:\"1\";s:9:\"protected\";s:1:\"0\";s:14:\"manifest_cache\";s:0:\"\";s:6:\"params\";s:0:\"\";s:11:\"custom_data\";s:0:\"\";s:11:\"system_data\";s:0:\"\";s:11:\"checked_out\";s:1:\"0\";s:16:\"checked_out_time\";s:19:\"0000-00-00 00:00:00\";s:8:\"ordering\";s:1:\"0\";s:5:\"state\";s:1:\"0\";}s:7:\"user_id\";i:1;s:16:\"shipping_address\";s:1:\"2\";s:15:\"billing_address\";s:1:\"2\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:12:\"NaturalChaos\";s:5:\"email\";s:21:\"ronin@ronincomics.com\";s:8:\"password\";s:32:\"396e5f08e5a03f1ac1abfa2b64224857\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-03-03 18:38:10\";s:13:\"lastvisitDate\";s:19:\"2011-03-28 20:47:51\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}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:13:\"session.token\";s:32:\"4c285679f58d0828bd9d7b110b7067c3\";}',	 `time` = 1301345448 
  WHERE `session_id` = '50ec9e71c9b7dd9788a6d2425a3ef55e'
46 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
16 × SELECT * FROM jos_hikashop_address
6 × SELECT b.*,c.* FROM jos_hikashop_cart_product AS b LEFT JOIN jos_hikashop_product AS c ON b.product_id=c.product_id
6 × SELECT a.* FROM jos_hikashop_zone_link AS a
4 × SELECT * FROM jos_hikashop_price
4 × SELECT * FROM jos_hikashop_discount
4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions
3 × SELECT g.id, g.title FROM jos_usergroups AS g JOIN jos_user_usergroup_map AS m ON m.group_id = g.id
3 × SELECT * FROM jos_hikashop_zone
3 × SELECT a.*,b.* FROM jos_hikashop_variant AS a LEFT JOIN jos_hikashop_characteristic AS b ON a.variant_characteristic_id=b.characteristic_id
3 × SELECT * FROM jos_users
3 × SELECT * FROM jos_hikashop_file
2 × SELECT a.*,b.* FROM jos_hikashop_user AS a LEFT JOIN jos_users AS b ON a.user_cms_id=b.id
2 × SELECT * FROM jos_hikashop_field as a
1 × SELECT a.* FROM jos_hikashop_zone AS a
1 × SELECT a.* FROM jos_hikashop_address AS a
1 × SELECT * FROM jos_menu
1 × SELECT * FROM jos_extensions
1 × SELECT * FROM jos_hikashop_paymen
1 × SELECT b.id FROM jos_user_usergroup_map AS map LEFT JOIN jos_usergroups AS a ON a.id = map.group_id LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `jos_viewlevels
1 × SELECT DISTINCT b.* FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_product AS b ON a.product_id=b.product_id
1 × SELECT count( DISTINCT b.product_id) FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_product AS b ON a.product_id=b.product_id
1 × SELECT DISTINCT b.product_id FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_product AS b ON a.product_id=b.product_id
1 × SELECT category_id FROM jos_hikashop_category
1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
1 × SELECT * FROM jos_hikashop_shipping
1 × SELECT folder AS type, element AS name, params FROM jos_extensions
1 × SELECT a.* FROM jos_hikashop_cart AS a
1 × SELECT * FROM jos_hikashop_confi
1 × SELECT currency_id FROM jos_hikashop_currency
1 × SELECT address_id FROM jos_hikashop_address
1 × SELECT id FROM jos_users
1 × SELECT `data` FROM `jos_session`
1 × SELECT id, home, template, params FROM jos_template_styles
1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
1 × SELECT id, password FROM jos_users
1 × SELECT b.*,c.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN jos_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey
1 × SELECT * FROM jos_hikashop_currency
1 × SELECT * FROM jos_languages
1 × SELECT `session_id` FROM `jos_session`
OTHER Tables:
1 × UPDATE `jos_users` SET `lastvisitDate` = '2011-03-28 20:50:47'
1 × UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1301345410;s:18:\"session.timer.last\";i:1301345414;s:17:\"session.timer.now\";i:1301345443;s:24:\"session.client.forwarded\";s:12:\"65.198.37.62\";s:22:\"session.client.browser\";s:120:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.16 (KHTML, like Gecko) Chrome/10.0.648.204 Safari/534.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":12:{s:7:\"cart_id\";i:11;s:11:\"currency_id\";i:2;s:7:\"zone_id\";s:4:\"4313\";s:15:\"shipping_method\";s:6:\"manual\";s:11:\"shipping_id\";i:4;s:13:\"shipping_data\";O:8:\"stdClass\":16:{s:11:\"shipping_id\";s:1:\"4\";s:13:\"shipping_type\";s:6:\"manual\";s:21:\"shipping_zone_namekey\";s:36:\"country_United_States_of_America_223\";s:15:\"shipping_tax_id\";s:2:\"15\";s:14:\"shipping_price\";s:7:\"0.00000\";s:20:\"shipping_currency_id\";s:1:\"2\";s:13:\"shipping_name\";s:13:\"Free Shipping\";s:20:\"shipping_description\";s:35:\"
Free shipping on all orders!
\";s:18:\"shipping_published\";s:1:\"1\";s:17:\"shipping_ordering\";s:1:\"3\";s:15:\"shipping_params\";O:8:\"stdClass\":9:{s:19:\"shipping_percentage\";s:1:\"0\";s:18:\"shipping_min_price\";s:0:\"\";s:18:\"shipping_max_price\";s:0:\"\";s:19:\"shipping_min_weight\";s:0:\"\";s:19:\"shipping_max_weight\";s:0:\"\";s:20:\"shipping_weight_unit\";s:2:\"oz\";s:19:\"shipping_min_volume\";s:0:\"\";s:19:\"shipping_max_volume\";s:0:\"\";s:18:\"shipping_size_unit\";s:2:\"in\";}s:15:\"shipping_images\";s:4:\"usps\";s:15:\"shipping_access\";s:3:\"all\";s:23:\"shipping_price_with_tax\";d:0;s:28:\"shipping_price_orig_with_tax\";d:0;s:5:\"total\";O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":7:{s:28:\"price_value_without_discount\";d:0;s:11:\"price_value\";d:34.9500000000000028421709430404007434844970703125;s:37:\"price_value_without_discount_with_tax\";d:0;s:20:\"price_value_with_tax\";d:37.219999999999998863131622783839702606201171875;s:17:\"price_currency_id\";i:2;s:37:\"price_value_without_shipping_with_tax\";d:37.219999999999998863131622783839702606201171875;s:28:\"price_value_without_shipping\";d:34.9500000000000028421709430404007434844970703125;}}}}s:14:\"payment_method\";s:6:\"paypal\";s:10:\"payment_id\";i:1;s:12:\"payment_data\";O:8:\"stdClass\":25:{s:10:\"payment_id\";s:1:\"1\";s:12:\"payment_name\";s:6:\"PayPal\";s:19:\"payment_description\";s:69:\"
You can pay by credit card or paypal using this payment method
\";s:14:\"payment_images\";s:6:\"PayPal\";s:14:\"payment_params\";O:8:\"stdClass\":12:{s:3:\"url\";s:37:\"https://www.paypal.com/cgi-bin/webscr\";s:5:\"email\";s:22:\"naturalchaos@gmail.com\";s:12:\"address_type\";s:8:\"shipping\";s:12:\"notification\";s:1:\"1\";s:5:\"debug\";s:1:\"0\";s:10:\"cancel_url\";s:0:\"\";s:10:\"return_url\";s:0:\"\";s:16:\"cpp_header_image\";s:5:\"98034\";s:3:\"ips\";a:4:{i:0;s:12:\"66.211.169.*\";i:1;s:10:\"64.4.241.*\";i:2;s:12:\"66.211.170.*\";i:3;s:13:\"216.113.191.*\";}s:14:\"invalid_status\";s:9:\"cancelled\";s:14:\"pending_status\";s:7:\"created\";s:15:\"verified_status\";s:9:\"confirmed\";}s:12:\"payment_type\";s:6:\"paypal\";s:20:\"payment_zone_namekey\";s:36:\"country_United_States_of_America_223\";s:14:\"payment_access\";s:3:\"all\";s:12:\"extension_id\";s:5:\"10015\";s:4:\"name\";s:30:\"HikaShop Paypal payment plugin\";s:4:\"type\";s:6:\"plugin\";s:7:\"element\";s:6:\"paypal\";s:6:\"folder\";s:15:\"hikashoppayment\";s:9:\"client_id\";s:1:\"0\";s:7:\"enabled\";s:1:\"1\";s:6:\"access\";s:1:\"1\";s:9:\"protected\";s:1:\"0\";s:14:\"manifest_cache\";s:0:\"\";s:6:\"params\";s:0:\"\";s:11:\"custom_data\";s:0:\"\";s:11:\"system_data\";s:0:\"\";s:11:\"checked_out\";s:1:\"0\";s:16:\"checked_out_time\";s:19:\"0000-00-00 00:00:00\";s:8:\"ordering\";s:1:\"0\";s:5:\"state\";s:1:\"0\";}s:7:\"user_id\";i:1;s:16:\"shipping_address\";s:1:\"2\";s:15:\"billing_address\";s:1:\"2\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:12:\"NaturalChaos\";s:5:\"email\";s:21:\"ronin@ronincomics.com\";s:8:\"password\";s:32:\"396e5f08e5a03f1ac1abfa2b64224857\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-03-03 18:38:10\";s:13:\"lastvisitDate\";s:19:\"2011-03-28 20:47:51\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}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:13:\"session.token\";s:32:\"4c285679f58d0828bd9d7b110b7067c3\";}', `time` = 1301345448
1 × UPDATE `jos_session` SET `guest` = '0', `username` = 'NaturalChaos', `userid` = 42
1 × SHOW FIELDS FROM jos_user
1 × UPDATE `jos_hikashop_cart` SET `session_id`='50ec9e71c9b7dd9788a6d2425a3ef55e',`cart_modified`='1301345443'
1 × DELETE FROM `jos_session`