37 Queries Logged
SELECT `data` 
  FROM `jos_session` 
  WHERE `session_id` = 'bf830830bff0d8e91c1e23892950cae1'
DELETE 
  FROM `jos_session` 
  WHERE `time` < '1341336467'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM jos_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
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,2,3) 
  ORDER BY ordering
SELECT template, s.params 
  FROM jos_template_styles as s 
  LEFT JOIN jos_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id 
  WHERE s.client_id = 1 
  AND home = 1 
  ORDER BY home
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM jos_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_hikashop'
SELECT * 
  FROM jos_hikashop_config
SELECT * 
  FROM jos_hikashop_product 
  WHERE product_id = '1396' 
  LIMIT 1
SELECT b.* 
  FROM jos_hikashop_product_category AS a 
  LEFT JOIN jos_hikashop_category AS b 
  ON a.category_id=b.category_id 
  WHERE a.product_id = 1396 
  ORDER BY a.product_category_id
SELECT a.*,b.* 
  FROM jos_hikashop_product_related AS a 
  LEFT JOIN jos_hikashop_product AS b 
  ON a.product_related_id=b.product_id 
  WHERE a.product_related_type='related' 
  AND a.product_id = 1396
SELECT a.*,b.* 
  FROM jos_hikashop_product_related AS a 
  LEFT JOIN jos_hikashop_product AS b 
  ON a.product_related_id=b.product_id 
  WHERE a.product_related_type='options' 
  AND a.product_id = 1396
SELECT * 
  FROM jos_hikashop_file 
  WHERE file_ref_id = 1396 
  AND file_type='product' 
  ORDER BY file_ordering, file_id
SELECT * 
  FROM jos_hikashop_file 
  WHERE file_ref_id = 1396 
  AND file_type='file' 
  ORDER BY file_ordering, file_id
SELECT a.ordering,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 = 1396 
  ORDER BY a.ordering
SELECT * 
  FROM jos_hikashop_price 
  WHERE price_product_id IN (1396)
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 = 11 
  AND b.taxation_published=1 
  AND ( taxation_type = '' OR taxation_type = 'individual' )
SELECT * 
  FROM jos_hikashop_zone 
  WHERE zone_id = 222
SHOW TABLES LIKE 'jos_falang_content'
SHOW TABLES LIKE 'jos_jf_content'
SELECT DISTINCT b.* 
  FROM jos_hikashop_category AS a 
  LEFT JOIN jos_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (33,87) 
  ORDER BY b.category_left
SELECT * 
  FROM jos_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.field_table='product' 
  AND ((field_with_sub_categories=0 
  AND (field_categories="all" OR field_categories LIKE '%,33,%' OR field_categories LIKE '%,87,%'))OR (field_with_sub_categories=1 
  AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,24,%' OR field_categories LIKE '%,33,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,53,%' OR field_categories LIKE '%,87,%'))) 
  ORDER BY a.`field_ordering` ASC
SELECT template 
  FROM jos_template_styles 
  WHERE client_id=0 
  AND home=1
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM jos_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_media'
SELECT category_id 
  FROM jos_hikashop_category 
  WHERE category_parent_id=0 
  LIMIT 1
SELECT a.category_name,a.category_id,a.category_namekey 
  FROM jos_hikashop_category AS a 
  WHERE a.category_type = 'tax' 
  AND a.category_parent_id!=1 
  ORDER BY a.category_ordering ASC
SELECT category_id 
  FROM jos_hikashop_category 
  WHERE category_parent_id=0 
  LIMIT 1
SELECT a.category_name,a.category_id,a.category_namekey 
  FROM jos_hikashop_category AS a 
  WHERE a.category_type = 'manufacturer' 
  AND a.category_parent_id!=1 
  ORDER BY a.category_ordering ASC
SELECT DISTINCT b.* 
  FROM jos_hikashop_category AS a 
  LEFT JOIN jos_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id=33 
  ORDER BY b.category_left
SELECT DISTINCT b.* 
  FROM jos_hikashop_category AS a 
  LEFT JOIN jos_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id=87 
  ORDER BY b.category_left
SELECT * 
  FROM jos_hikashop_currency 
  WHERE currency_published=1 OR currency_id IN ('4','4')
SELECT b.*, a.*, c.currency_symbol 
  FROM jos_hikashop_shipping AS a 
  LEFT JOIN jos_hikashop_shipping_price AS b 
  ON a.shipping_id = b.shipping_id 
  AND b.shipping_price_ref_id = 1396 
  INNER JOIN jos_hikashop_currency AS c 
  ON c.currency_id = a.shipping_currency_id 
  WHERE a.shipping_type = 'manual' 
  AND a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' 
  AND b.shipping_price_ref_id IS NULL OR (b.shipping_price_ref_id = 1396 
  AND b.shipping_price_ref_type = 'product') 
  ORDER BY a.shipping_id, b.shipping_price_min_quantity
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 <= '2012-07-03 17:42:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-07-03 17:42:47') 
  AND m.access IN (1,1,2,3) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  ORDER BY m.position, m.ordering
SELECT COUNT(*) 
  FROM jos_messages 
  WHERE state = 0 
  AND user_id_to = 42
SELECT COUNT(session_id) 
  FROM jos_session 
  WHERE guest = 0 
  AND client_id = 1
SELECT COUNT(session_id) 
  FROM jos_session 
  WHERE guest = 0 
  AND client_id = 0
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id 
  WHERE m.client_id = 1 
  AND e.enabled = 1 
  AND m.id > 1 
  ORDER BY m.lft
UPDATE `jos_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:63;s:19:\"session.timer.start\";i:1341335929;s:18:\"session.timer.last\";i:1341337363;s:17:\"session.timer.now\";i:1341337367;s:22:\"session.client.browser\";s:119:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_4) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.11\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:12:\"com_hikashop\";O:8:\"stdClass\":3:{s:7:\"zone_id\";s:4:\"4228\";s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"87\";}s:14:\"characteristic\";O:8:\"stdClass\":5:{s:12:\"filter_order\";s:19:\"a.characteristic_id\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:6:\"search\";s:0:\"\";s:10:\"list_limit\";i:20;s:10:\"limitstart\";i:0;}}s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:35:\"martyn.a@servicepointsoftware.co.uk\";s:8:\"password\";s:65:\"c93502cb8472cd71270a933c0cf6b83e:GwCZjuHdTK3HFKQ7BQowaIkzkGsqilRp\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-12-14 12:37:34\";s:13:\"lastvisitDate\";s:19:\"2012-07-03 10:13:14\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}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:\"959cca28e58ca5149479920f813e4bb8\";}hikashop_product_data|O:8:\"stdClass\":32:{s:12:\"product_name\";s:27:\"Test Contintental Mens shoe\";s:11:\"product_url\";s:0:\"\";s:24:\"product_meta_description\";s:0:\"\";s:16:\"product_keywords\";s:0:\"\";s:12:\"product_code\";s:8:\"99988877\";s:14:\"product_tax_id\";s:2:\"11\";s:23:\"product_manufacturer_id\";s:2:\"40\";s:18:\"product_sale_start\";s:0:\"\";s:16:\"product_sale_end\";s:0:\"\";s:14:\"product_layout\";s:0:\"\";s:16:\"product_quantity\";i:-1;s:21:\"product_min_per_order\";s:1:\"0\";s:21:\"product_max_per_order\";i:0;s:14:\"product_weight\";s:5:\"0.000\";s:19:\"product_weight_unit\";s:2:\"kg\";s:14:\"product_length\";s:5:\"0.000\";s:13:\"product_width\";s:5:\"0.000\";s:22:\"product_dimension_unit\";s:1:\"m\";s:14:\"product_height\";s:5:\"0.000\";s:17:\"product_published\";s:1:\"0\";s:12:\"product_type\";s:4:\"main\";s:10:\"product_id\";i:1396;s:10:\"categories\";a:2:{i:33;i:33;i:87;i:87;}s:7:\"related\";a:0:{}s:7:\"options\";a:0:{}s:6:\"images\";a:0:{}s:5:\"files\";a:0:{}s:11:\"imagesorder\";a:0:{}s:6:\"prices\";a:2:{i:0;O:8:\"stdClass\":4:{s:11:\"price_value\";s:8:\"37.50000\";s:17:\"price_currency_id\";i:4;s:18:\"price_min_quantity\";i:0;s:8:\"price_id\";i:79;}s:2:\"##\";O:8:\"stdClass\":3:{s:11:\"price_value\";d:0;s:17:\"price_currency_id\";i:4;s:18:\"price_min_quantity\";i:0;}}s:18:\"oldCharacteristics\";a:0:{}s:19:\"product_description\";s:26:\"<p>This is a test item</p>\";s:16:\"product_modified\";i:1341337363;}' , `time` = '1341337367' 
  WHERE `session_id` = 'bf830830bff0d8e91c1e23892950cae1'
28 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × SELECT DISTINCT b.* 
  FROM jos_hikashop_category AS a 
  LEFT JOIN jos_hikashop_category AS b 
  ON a.category_left >= b.category_left
3 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM jos_extensions
2 × SELECT a.category_name,a.category_id,a.category_namekey 
  FROM jos_hikashop_category AS a
2 × SELECT category_id 
  FROM jos_hikashop_category
2 × SELECT COUNT(session_id) 
  FROM jos_session
2 × SELECT a.*,b.* 
  FROM jos_hikashop_product_related AS a 
  LEFT JOIN jos_hikashop_product AS b 
  ON a.product_related_id=b.product_id
2 × SELECT * 
  FROM jos_hikashop_file
1 × SELECT template 
  FROM jos_template_styles
1 × SELECT * 
  FROM jos_hikashop_currency
1 × SELECT b.*, a.*, c.currency_symbol 
  FROM jos_hikashop_shipping AS a 
  LEFT JOIN jos_hikashop_shipping_price AS b 
  ON a.shipping_id = b.shipping_id 
  AND b.shipping_price_ref_id = 1396 
  INNER JOIN jos_hikashop_currency AS c 
  ON c.currency_id = a.shipping_currency_id
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT COUNT(*) 
  FROM jos_messages
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
1 × SELECT * 
  FROM jos_hikashop_field as a
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_confi
1 × SELECT template, s.params 
  FROM jos_template_styles as s 
  LEFT JOIN jos_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id
1 × SELECT folder AS type, element AS name, params 
  FROM jos_extensions
1 × SELECT * 
  FROM jos_hikashop_product
1 × SELECT b.* 
  FROM jos_hikashop_product_category AS a 
  LEFT JOIN jos_hikashop_category AS b 
  ON a.category_id=b.category_id
1 × SELECT `data` 
  FROM `jos_session`
1 × SELECT * 
  FROM jos_hikashop_price
1 × SELECT a.ordering,b.* 
  FROM jos_hikashop_variant AS a 
  LEFT JOIN jos_hikashop_characteristic AS b 
  ON a.variant_characteristic_id=b.characteristic_id
1 × SELECT * 
  FROM jos_hikashop_zone
OTHER Tables:
1 × UPDATE `jos_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:63;s:19:\"session.timer.start\";i:1341335929;s:18:\"session.timer.last\";i:1341337363;s:17:\"session.timer.now\";i:1341337367;s:22:\"session.client.browser\";s:119:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_4) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.11\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:12:\"com_hikashop\";O:8:\"stdClass\":3:{s:7:\"zone_id\";s:4:\"4228\";s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"87\";}s:14:\"characteristic\";O:8:\"stdClass\":5:{s:12:\"filter_order\";s:19:\"a.characteristic_id\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:6:\"search\";s:0:\"\";s:10:\"list_limit\";i:20;s:10:\"limitstart\";i:0;}}s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:35:\"martyn.a@servicepointsoftware.co.uk\";s:8:\"password\";s:65:\"c93502cb8472cd71270a933c0cf6b83e:GwCZjuHdTK3HFKQ7BQowaIkzkGsqilRp\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-12-14 12:37:34\";s:13:\"lastvisitDate\";s:19:\"2012-07-03 10:13:14\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}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:\"959cca28e58ca5149479920f813e4bb8\";}hikashop_product_data|O:8:\"stdClass\":32:{s:12:\"product_name\";s:27:\"Test Contintental Mens shoe\";s:11:\"product_url\";s:0:\"\";s:24:\"product_meta_description\";s:0:\"\";s:16:\"product_keywords\";s:0:\"\";s:12:\"product_code\";s:8:\"99988877\";s:14:\"product_tax_id\";s:2:\"11\";s:23:\"product_manufacturer_id\";s:2:\"40\";s:18:\"product_sale_start\";s:0:\"\";s:16:\"product_sale_end\";s:0:\"\";s:14:\"product_layout\";s:0:\"\";s:16:\"product_quantity\";i:-1;s:21:\"product_min_per_order\";s:1:\"0\";s:21:\"product_max_per_order\";i:0;s:14:\"product_weight\";s:5:\"0.000\";s:19:\"product_weight_unit\";s:2:\"kg\";s:14:\"product_length\";s:5:\"0.000\";s:13:\"product_width\";s:5:\"0.000\";s:22:\"product_dimension_unit\";s:1:\"m\";s:14:\"product_height\";s:5:\"0.000\";s:17:\"product_published\";s:1:\"0\";s:12:\"product_type\";s:4:\"main\";s:10:\"product_id\";i:1396;s:10:\"categories\";a:2:{i:33;i:33;i:87;i:87;}s:7:\"related\";a:0:{}s:7:\"options\";a:0:{}s:6:\"images\";a:0:{}s:5:\"files\";a:0:{}s:11:\"imagesorder\";a:0:{}s:6:\"prices\";a:2:{i:0;O:8:\"stdClass\":4:{s:11:\"price_value\";s:8:\"37.50000\";s:17:\"price_currency_id\";i:4;s:18:\"price_min_quantity\";i:0;s:8:\"price_id\";i:79;}s:2:\"##\";O:8:\"stdClass\":3:{s:11:\"price_value\";d:0;s:17:\"price_currency_id\";i:4;s:18:\"price_min_quantity\";i:0;}}s:18:\"oldCharacteristics\";a:0:{}s:19:\"product_description\";s:26:\"<p>This is a test item</p>\";s:16:\"product_modified\";i:1341337363;}' , `time` = '1341337367'
1 × SHOW TABLES LIKE 'jos_jf_content
1 × SHOW TABLES LIKE 'jos_falang_content
1 × DELETE 
  FROM `jos_session`