120102 14:34:25 32 Connect commerce@localhost on commerce 32 Query SET NAMES utf8 32 Query SET sql_mode='ANSI,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER' 32 Query SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN ('variables') 32 Query SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN ('bootstrap_modules') 32 Query SELECT 1 FROM blocked_ips WHERE ip = '127.0.0.1' 32 Query SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'dp0a0iLAXlziV-0KhX4Nfj1Eth5sTAgOBjSc6UzxJ28' 32 Query SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = '1' 32 Query SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN ('lookup_cache') 32 Query SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN ('system_list') 32 Query SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN ('module_implements') 32 Query SELECT source FROM url_alias WHERE alias = 'cart' AND language IN ('en', 'und') ORDER BY language ASC, pid DESC 32 Query SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN ('menu_item:1c42ddc0285b9c25135be3bf345e6a041271b784b22a6f6cab6588dab93c5980') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('theme_registry:bartik') 32 Query SELECT * FROM commerce_checkout_pane 32 Query SELECT order_id FROM commerce_order WHERE uid = '1' AND status IN ('cart', 'checkout_checkout', 'checkout_shipping', 'checkout_review') ORDER BY order_id DESC 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('entity_info:en') 32 Query START TRANSACTION 32 Query SELECT revision.order_number AS order_number, revision.revision_id AS revision_id, revision.revision_uid AS revision_uid, revision.mail AS mail, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.revision_hostname AS revision_hostname, revision.data AS data, base.order_id AS order_id, base.type AS type, base.uid AS uid, base.created AS created, base.changed AS changed, base.hostname AS hostname FROM commerce_order base INNER JOIN commerce_order_revision revision ON revision.revision_id = base.revision_id WHERE (base.order_id IN ('3')) FOR UPDATE 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field_info_fields') 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_order:3') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_order' AND entity_id IN ('3') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('entity_property_info:en') 32 Query SELECT base.line_item_id AS line_item_id, base.order_id AS order_id, base.type AS type, base.line_item_label AS line_item_label, base.quantity AS quantity, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_line_item base WHERE (base.line_item_id IN ('645')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_line_item:645') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_line_item' AND entity_id IN ('645') 32 Query SELECT base.product_id AS product_id, base.sku AS sku, base.type AS type, base.language AS language, base.title AS title, base.uid AS uid, base.status AS status, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_product base WHERE (base.product_id IN ('4')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_product:4') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_product' AND entity_id IN ('4') 32 Query SELECT base.product_id AS product_id, base.sku AS sku, base.type AS type, base.language AS language, base.title AS title, base.uid AS uid, base.status AS status, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_product base WHERE (base.product_id IN ('4')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_product:4') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_product' AND entity_id IN ('4') 32 Query SELECT cid, data, created, expire, serialized FROM cache_rules WHERE cid IN ('event_commerce_product_calculate_sell_price') 32 Query SELECT cid, data, created, expire, serialized FROM cache_rules WHERE cid IN ('data:en') 32 Query SELECT * FROM commerce_tax_type 32 Query SELECT base.id AS id, base.name AS name, base.label AS label, base.plugin AS plugin, base.active AS active, base.weight AS weight, base.status AS status, base.dirty AS dirty, base.module AS module, base.data AS data FROM rules_config base WHERE (base.plugin IN ('or', 'and', 'action set', 'rule', 'rule set')) 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('schema:runtime:') 32 Query SELECT rules_tags.id AS id, rules_tags.tag AS tag FROM rules_tags rules_tags WHERE (id IN ('25', '27', '33', '34', '35', '42', '44', '46', '49', '50', '52')) 32 Query SELECT rules_dependencies.id AS id, rules_dependencies.module AS module FROM rules_dependencies rules_dependencies WHERE (id IN ('25', '27', '33', '34', '35', '42', '44', '46', '49', '50', '52')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:rules_config:25', 'field:rules_config:27', 'field:rules_config:33', 'field:rules_config:34', 'field:rules_config:35', 'field:rules_config:42', 'field:rules_config:44', 'field:rules_config:46', 'field:rules_config:49', 'field:rules_config:50', 'field:rules_config:52') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'rules_config' AND entity_id IN ('25', '27', '33', '34', '35', '42', '44', '46', '49', '50', '52') 32 Query SELECT * FROM commerce_tax_rate 32 Query SELECT cid, data, created, expire, serialized FROM cache_rules WHERE cid IN ('comp_commerce_tax_rate_maryland_sales_tax') 32 Query SELECT base.id AS id, base.name AS name, base.label AS label, base.plugin AS plugin, base.active AS active, base.weight AS weight, base.status AS status, base.dirty AS dirty, base.module AS module, base.data AS data FROM rules_config base WHERE (base.plugin IN ('or', 'and', 'action set', 'rule', 'rule set')) 33 Connect SBOData@localhost on 33 Init DB SBOData 33 Query SELECT Price FROM ITM1 WHERE ItemCode = '7NN-P1-NEW-VXXZ-BE' 32 Query SELECT base.line_item_id AS line_item_id, base.order_id AS order_id, base.type AS type, base.line_item_label AS line_item_label, base.quantity AS quantity, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_line_item base WHERE (base.line_item_id IN ('646')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_line_item:646') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_line_item' AND entity_id IN ('646') 32 Query SELECT base.product_id AS product_id, base.sku AS sku, base.type AS type, base.language AS language, base.title AS title, base.uid AS uid, base.status AS status, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_product base WHERE (base.product_id IN ('12')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_product:12') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_product' AND entity_id IN ('12') 32 Query SELECT base.product_id AS product_id, base.sku AS sku, base.type AS type, base.language AS language, base.title AS title, base.uid AS uid, base.status AS status, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_product base WHERE (base.product_id IN ('12')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_product:12') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_product' AND entity_id IN ('12') 32 Query SELECT base.id AS id, base.name AS name, base.label AS label, base.plugin AS plugin, base.active AS active, base.weight AS weight, base.status AS status, base.dirty AS dirty, base.module AS module, base.data AS data FROM rules_config base WHERE (base.plugin IN ('or', 'and', 'action set', 'rule', 'rule set')) 32 Query SELECT base.id AS id, base.name AS name, base.label AS label, base.plugin AS plugin, base.active AS active, base.weight AS weight, base.status AS status, base.dirty AS dirty, base.module AS module, base.data AS data FROM rules_config base WHERE (base.plugin IN ('or', 'and', 'action set', 'rule', 'rule set')) 33 Init DB SBOData 33 Query SELECT Price FROM ITM1 WHERE ItemCode = '7NN-P2-NEW-VXXZ-BE' 32 Query SELECT t__0.* FROM views_view t__0 WHERE (name IN ('commerce_cart_form')) 32 Query SELECT * FROM views_display WHERE vid IN ('2') ORDER BY vid, position 32 Query SELECT cid, data, created, expire, serialized FROM cache_views WHERE cid IN ('ctools_export:views_view:commerce_cart_form') 32 Query SELECT cid, data, created, expire, serialized FROM cache_views WHERE cid IN ('views_data:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache_views WHERE cid IN ('unpack_options:063ce20e92e5e6d7956e35e06cb1ccf9:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field_info_types:en') 32 Query SELECT o.order_number FROM commerce_order o WHERE o.order_id IN ('3') 32 Query SELECT commerce_line_item_field_data_commerce_line_items.line_item_id AS commerce_line_item_field_data_commerce_line_items_line_item_, commerce_line_item_field_data_commerce_line_items.quantity AS commerce_line_item_field_data_commerce_line_items_quantity, commerce_line_item_field_data_commerce_line_items__field_data_field_sub_line_item.field_sub_line_item_value AS commerce_line_item_field_data_commerce_line_items__field_dat, commerce_line_item_field_data_commerce_line_items.line_item_label AS commerce_line_item_field_data_commerce_line_items_line_item__1, 'commerce_line_item' AS field_data_field_css_class_commerce_line_item_entity_type, 'commerce_line_item' AS field_data_commerce_display_path_commerce_line_item_entity_t, 'commerce_line_item' AS field_data_commerce_unit_price_commerce_line_item_entity_typ, 'commerce_line_item' AS field_data_commerce_total_commerce_line_item_entity_type, 'commerce_line_item' AS field_data_field_sub_line_item_commerce_line_item_entity_typ FROM commerce_order commerce_order LEFT JOIN field_data_commerce_line_items field_data_commerce_line_items ON commerce_order.order_id = field_data_commerce_line_items.entity_id AND (field_data_commerce_line_items.entity_type = 'commerce_order' AND field_data_commerce_line_items.deleted = '0') INNER JOIN commerce_line_item commerce_line_item_field_data_commerce_line_items ON field_data_commerce_line_items.commerce_line_items_line_item_id = commerce_line_item_field_data_commerce_line_items.line_item_id LEFT JOIN field_data_field_sub_line_item commerce_line_item_field_data_commerce_line_items__field_data_field_sub_line_item ON commerce_line_item_field_data_commerce_line_items.line_item_id = commerce_line_item_field_data_commerce_line_items__field_data_field_sub_line_item.entity_id AND (commerce_line_item_field_data_commerce_line_items__field_data_field_sub_line_item.entity_type = 'commerce_line_item' AND commerce_line_item_field_data_commerce_line_items__field_data_field_sub_line_item.deleted = '0') WHERE (( (commerce_line_item_field_data_commerce_line_items.type IN ('product')) AND (commerce_order.order_id = '3' ) )) ORDER BY commerce_line_item_field_data_commerce_line_items__field_dat ASC, commerce_line_item_field_data_commerce_line_items_line_item__1 ASC 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('filter_formats:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('filter_list_format') 32 Query SELECT cid, data, created, expire, serialized FROM cache_form WHERE cid IN ('form_form-5clw1DS0qf724s8frlApIxf_Bq3pYvIj3nJCgOJQdiY') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('node_types:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('ctools_plugin_type_info') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('plugins:feeds:plugins') 32 Query SELECT cid, data, created, expire, serialized FROM cache_path WHERE cid IN ('cart') 32 Query SELECT source, alias FROM url_alias WHERE source IN ('node/4', 'node/5', 'node/8', 'node/9', 'node/7', 'node/6', 'node/10', 'node/11', 'node/add/product-display') AND language IN ('en', 'und') ORDER BY language ASC, pid ASC 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN ('hook_info') 32 Query SAVEPOINT savepoint_1 32 Query SELECT base.line_item_id AS line_item_id, base.order_id AS order_id, base.type AS type, base.line_item_label AS line_item_label, base.quantity AS quantity, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_line_item base WHERE (base.line_item_id IN ('646')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_line_item:646') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_line_item' AND entity_id IN ('646') 32 Query UPDATE commerce_line_item SET order_id='3', type='product', line_item_label='7NN-P2-NEW-VXXZ-BE', quantity='4444', created='1325532851', changed='1325532865', data='a:0:{}' WHERE (line_item_id = '646') 32 Query DELETE FROM field_data_commerce_unit_price WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_unit_price WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_unit_price (entity_type, entity_id, revision_id, bundle, delta, language, commerce_unit_price_amount, commerce_unit_price_currency_code, commerce_unit_price_data) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '144100', 'USD', 'a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";s:6:\"144100\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:8646;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}') 32 Query INSERT INTO field_revision_commerce_unit_price (entity_type, entity_id, revision_id, bundle, delta, language, commerce_unit_price_amount, commerce_unit_price_currency_code, commerce_unit_price_data) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '144100', 'USD', 'a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";s:6:\"144100\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:8646;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}') 32 Query DELETE FROM field_data_commerce_total WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_total WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 120102 14:34:26 32 Query INSERT INTO field_data_commerce_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_total_amount, commerce_total_currency_code, commerce_total_data) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '640380400', 'USD', 'a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:640380400;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:38422824;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}') 32 Query INSERT INTO field_revision_commerce_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_total_amount, commerce_total_currency_code, commerce_total_data) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '640380400', 'USD', 'a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:640380400;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:38422824;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}') 32 Query DELETE FROM field_data_commerce_product WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_product WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_product (entity_type, entity_id, revision_id, bundle, delta, language, commerce_product_product_id) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '12') 32 Query INSERT INTO field_revision_commerce_product (entity_type, entity_id, revision_id, bundle, delta, language, commerce_product_product_id) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '12') 32 Query DELETE FROM field_data_commerce_display_path WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_display_path WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_display_path (entity_type, entity_id, revision_id, bundle, delta, language, commerce_display_path_value, commerce_display_path_format) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '', NULL) 32 Query INSERT INTO field_revision_commerce_display_path (entity_type, entity_id, revision_id, bundle, delta, language, commerce_display_path_value, commerce_display_path_format) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '', NULL) 32 Query DELETE FROM field_data_field_short_name WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_field_short_name WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_data_field_sub_line_item WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_field_sub_line_item WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_field_sub_line_item (entity_type, entity_id, revision_id, bundle, delta, language, field_sub_line_item_value) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '645') 32 Query INSERT INTO field_revision_field_sub_line_item (entity_type, entity_id, revision_id, bundle, delta, language, field_sub_line_item_value) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '645') 32 Query DELETE FROM field_data_field_css_class WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_field_css_class WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_field_css_class (entity_type, entity_id, revision_id, bundle, delta, language, field_css_class_value, field_css_class_format) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', 'full_product', NULL) 32 Query INSERT INTO field_revision_field_css_class (entity_type, entity_id, revision_id, bundle, delta, language, field_css_class_value, field_css_class_format) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', 'full_product', NULL) 32 Query DELETE FROM cache_field WHERE (cid = 'field:commerce_line_item:646') 32 Query RELEASE SAVEPOINT savepoint_1 32 Query SELECT cid, data, created, expire, serialized FROM cache_rules WHERE cid IN ('event_commerce_cart_product_remove') 32 Query SAVEPOINT savepoint_1 32 Query SELECT DISTINCT field_data_commerce_line_items0.entity_type AS entity_type, field_data_commerce_line_items0.entity_id AS entity_id, field_data_commerce_line_items0.revision_id AS revision_id, field_data_commerce_line_items0.bundle AS bundle FROM field_data_commerce_line_items field_data_commerce_line_items0 WHERE (field_data_commerce_line_items0.commerce_line_items_line_item_id = '645') AND (field_data_commerce_line_items0.deleted = '0') 32 Query SAVEPOINT savepoint_2 32 Query SELECT base.line_item_id AS line_item_id, base.order_id AS order_id, base.type AS type, base.line_item_label AS line_item_label, base.quantity AS quantity, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_line_item base WHERE (base.line_item_id IN ('646')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_line_item:646') 32 Query SELECT t.* FROM field_data_commerce_unit_price t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_total t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_product t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_display_path t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_field_short_name t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_field_sub_line_item t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_field_css_class t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SAVEPOINT savepoint_3 32 Query SELECT 1 AS expression FROM cache_field cache_field WHERE ( (cid = 'field:commerce_line_item:646') ) FOR UPDATE 32 Query INSERT INTO cache_field (cid, serialized, created, expire, data) VALUES ('field:commerce_line_item:646', '1', '1325532865', '0', 'a:7:{s:19:\"commerce_unit_price\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:6:\"amount\";s:6:\"144100\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";s:6:\"144100\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:8646;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}}}}s:14:\"commerce_total\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:6:\"amount\";s:9:\"640380400\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:640380400;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:38422824;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}}}}s:16:\"commerce_product\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:10:\"product_id\";s:2:\"12\";}}}s:21:\"commerce_display_path\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:5:\"value\";s:0:\"\";s:6:\"format\";N;s:10:\"safe_value\";s:0:\"\";}}}s:16:\"field_short_name\";a:0:{}s:19:\"field_sub_line_item\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:5:\"value\";s:5:\"645.0\";}}}s:15:\"field_css_class\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:5:\"value\";s:12:\"full_product\";s:6:\"format\";N;s:10:\"safe_value\";s:12:\"full_product\";}}}}') 32 Query RELEASE SAVEPOINT savepoint_3 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_line_item' AND entity_id IN ('646') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SAVEPOINT savepoint_3 32 Query SELECT revision.order_number AS order_number, revision.revision_id AS revision_id, revision.revision_uid AS revision_uid, revision.mail AS mail, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.revision_hostname AS revision_hostname, revision.data AS data, base.order_id AS order_id, base.type AS type, base.uid AS uid, base.created AS created, base.changed AS changed, base.hostname AS hostname FROM commerce_order base INNER JOIN commerce_order_revision revision ON revision.revision_id = base.revision_id WHERE (base.order_id IN ('3')) FOR UPDATE 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_order:3') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_order' AND entity_id IN ('3') 32 Query UPDATE commerce_order SET order_number='3', revision_id='230', type='commerce_order', uid='1', mail='banderson@vectorworks.net', status='cart', created='1324404432', changed='1325532865', hostname='127.0.0.1', data='a:0:{}' WHERE (order_id = '3') 32 Query UPDATE commerce_order_revision SET order_id='3', order_number='3', revision_uid='1', mail='banderson@vectorworks.net', status='cart', log='Customer updated the order via the shopping cart form.', revision_timestamp='1325532865', revision_hostname='127.0.0.1', data='a:0:{}' WHERE (revision_id = '230') 32 Query RELEASE SAVEPOINT savepoint_3 32 Query DELETE FROM field_data_commerce_line_items WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_line_items WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '230') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_line_items (entity_type, entity_id, revision_id, bundle, delta, language, commerce_line_items_line_item_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '646') 32 Query INSERT INTO field_revision_commerce_line_items (entity_type, entity_id, revision_id, bundle, delta, language, commerce_line_items_line_item_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '646') 32 Query DELETE FROM field_data_commerce_order_total WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_order_total WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '230') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_order_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_order_total_amount, commerce_order_total_currency_code, commerce_order_total_data) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '678803224', 'USD', 'a:1:{s:10:\"components\";a:2:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:640380400;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:38422824;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}}}') 32 Query INSERT INTO field_revision_commerce_order_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_order_total_amount, commerce_order_total_currency_code, commerce_order_total_data) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '678803224', 'USD', 'a:1:{s:10:\"components\";a:2:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:640380400;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:38422824;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}}}') 32 Query DELETE FROM field_data_commerce_customer_billing WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_customer_billing WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '230') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_customer_billing (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_billing_profile_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '1') 32 Query INSERT INTO field_revision_commerce_customer_billing (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_billing_profile_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '1') 32 Query DELETE FROM field_data_commerce_customer_shipping WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_customer_shipping WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '230') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_customer_shipping (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_shipping_profile_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '2') 32 Query INSERT INTO field_revision_commerce_customer_shipping (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_shipping_profile_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '2') 32 Query DELETE FROM cache_field WHERE (cid = 'field:commerce_order:3') 32 Query DELETE FROM cache_commerce_shipping_rates WHERE (cid LIKE '3:%' ESCAPE '\\') 32 Query SELECT cid, data, created, expire, serialized FROM cache_rules WHERE cid IN ('event_commerce_order_update') 32 Query RELEASE SAVEPOINT savepoint_2 32 Query DELETE FROM commerce_line_item WHERE (line_item_id IN ('645')) 32 Query DELETE FROM field_data_commerce_unit_price WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_revision_commerce_unit_price WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_data_commerce_total WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_revision_commerce_total WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_data_commerce_product WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_revision_commerce_product WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_data_commerce_display_path WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_revision_commerce_display_path WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_data_field_short_name WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_revision_field_short_name WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_data_field_sub_line_item WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_revision_field_sub_line_item WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_data_field_css_class WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM field_revision_field_css_class WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query DELETE FROM cache_field WHERE (cid = 'field:commerce_line_item:645') 32 Query DELETE FROM feeds_item WHERE (entity_type = 'commerce_line_item') AND (entity_id = '645') 32 Query RELEASE SAVEPOINT savepoint_1 32 Query commit 32 Query START TRANSACTION 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SAVEPOINT savepoint_1 32 Query SELECT revision.order_number AS order_number, revision.revision_id AS revision_id, revision.revision_uid AS revision_uid, revision.mail AS mail, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.revision_hostname AS revision_hostname, revision.data AS data, base.order_id AS order_id, base.type AS type, base.uid AS uid, base.created AS created, base.changed AS changed, base.hostname AS hostname FROM commerce_order base INNER JOIN commerce_order_revision revision ON revision.revision_id = base.revision_id WHERE (base.order_id IN ('3')) FOR UPDATE 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_order:3') 32 Query SELECT t.* FROM field_data_commerce_line_items t WHERE (entity_type = 'commerce_order') AND (entity_id IN ('3')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_order_total t WHERE (entity_type = 'commerce_order') AND (entity_id IN ('3')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_customer_billing t WHERE (entity_type = 'commerce_order') AND (entity_id IN ('3')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_customer_shipping t WHERE (entity_type = 'commerce_order') AND (entity_id IN ('3')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SAVEPOINT savepoint_2 32 Query SELECT 1 AS expression FROM cache_field cache_field WHERE ( (cid = 'field:commerce_order:3') ) FOR UPDATE 32 Query INSERT INTO cache_field (cid, serialized, created, expire, data) VALUES ('field:commerce_order:3', '1', '1325532865', '0', 'a:4:{s:19:\"commerce_line_items\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:12:\"line_item_id\";s:3:\"646\";}}}s:20:\"commerce_order_total\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:6:\"amount\";s:9:\"678803224\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:2:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:640380400;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:38422824;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}}}}}}s:25:\"commerce_customer_billing\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:10:\"profile_id\";s:1:\"1\";}}}s:26:\"commerce_customer_shipping\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:10:\"profile_id\";s:1:\"2\";}}}}') 32 Query RELEASE SAVEPOINT savepoint_2 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_order' AND entity_id IN ('3') 32 Query UPDATE commerce_order SET order_number='3', revision_id='230', type='commerce_order', uid='1', mail='banderson@vectorworks.net', status='cart', created='1324404432', changed='1325532865', hostname='127.0.0.1', data='a:0:{}' WHERE (order_id = '3') 32 Query UPDATE commerce_order_revision SET order_id='3', order_number='3', revision_uid='1', mail='banderson@vectorworks.net', status='cart', log='Customer updated the order via the shopping cart form.', revision_timestamp='1325532865', revision_hostname='127.0.0.1', data='a:0:{}' WHERE (revision_id = '230') 32 Query RELEASE SAVEPOINT savepoint_1 32 Query DELETE FROM field_data_commerce_line_items WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_line_items WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '230') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_line_items (entity_type, entity_id, revision_id, bundle, delta, language, commerce_line_items_line_item_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '646') 32 Query INSERT INTO field_revision_commerce_line_items (entity_type, entity_id, revision_id, bundle, delta, language, commerce_line_items_line_item_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '646') 32 Query DELETE FROM field_data_commerce_order_total WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_order_total WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '230') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_order_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_order_total_amount, commerce_order_total_currency_code, commerce_order_total_data) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '678803224', 'USD', 'a:1:{s:10:\"components\";a:2:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:640380400;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:38422824;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}}}') 32 Query INSERT INTO field_revision_commerce_order_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_order_total_amount, commerce_order_total_currency_code, commerce_order_total_data) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '678803224', 'USD', 'a:1:{s:10:\"components\";a:2:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:640380400;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:38422824;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}}}') 32 Query DELETE FROM field_data_commerce_customer_billing WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_customer_billing WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '230') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_customer_billing (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_billing_profile_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '1') 32 Query INSERT INTO field_revision_commerce_customer_billing (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_billing_profile_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '1') 32 Query DELETE FROM field_data_commerce_customer_shipping WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_customer_shipping WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '230') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_customer_shipping (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_shipping_profile_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '2') 32 Query INSERT INTO field_revision_commerce_customer_shipping (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_shipping_profile_id) VALUES ('commerce_order', '3', '230', 'commerce_order', '0', 'und', '2') 32 Query DELETE FROM cache_field WHERE (cid = 'field:commerce_order:3') 32 Query DELETE FROM cache_commerce_shipping_rates WHERE (cid LIKE '3:%' ESCAPE '\\') 32 Query commit 32 Query START TRANSACTION 32 Query SELECT base.line_item_id AS line_item_id, base.order_id AS order_id, base.type AS type, base.line_item_label AS line_item_label, base.quantity AS quantity, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_line_item base WHERE (base.line_item_id IN ('646')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_line_item:646') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_line_item' AND entity_id IN ('646') 32 Query UPDATE commerce_line_item SET order_id='3', type='product', line_item_label='7NN-P2-NEW-VXXZ-BE', quantity='121', created='1325532851', changed='1325532865', data='a:0:{}' WHERE (line_item_id = '646') 32 Query DELETE FROM field_data_commerce_unit_price WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_unit_price WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_unit_price (entity_type, entity_id, revision_id, bundle, delta, language, commerce_unit_price_amount, commerce_unit_price_currency_code, commerce_unit_price_data) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '144100', 'USD', 'a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";s:6:\"144100\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:8646;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}') 32 Query INSERT INTO field_revision_commerce_unit_price (entity_type, entity_id, revision_id, bundle, delta, language, commerce_unit_price_amount, commerce_unit_price_currency_code, commerce_unit_price_data) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '144100', 'USD', 'a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";s:6:\"144100\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:8646;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}') 32 Query DELETE FROM field_data_commerce_total WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_total WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_total_amount, commerce_total_currency_code, commerce_total_data) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '17436100', 'USD', 'a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:17436100;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:1046166;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}') 32 Query INSERT INTO field_revision_commerce_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_total_amount, commerce_total_currency_code, commerce_total_data) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '17436100', 'USD', 'a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:17436100;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:1046166;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}') 32 Query DELETE FROM field_data_commerce_product WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_product WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_product (entity_type, entity_id, revision_id, bundle, delta, language, commerce_product_product_id) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '12') 32 Query INSERT INTO field_revision_commerce_product (entity_type, entity_id, revision_id, bundle, delta, language, commerce_product_product_id) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '12') 32 Query DELETE FROM field_data_commerce_display_path WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_display_path WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_display_path (entity_type, entity_id, revision_id, bundle, delta, language, commerce_display_path_value, commerce_display_path_format) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '', NULL) 32 Query INSERT INTO field_revision_commerce_display_path (entity_type, entity_id, revision_id, bundle, delta, language, commerce_display_path_value, commerce_display_path_format) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '', NULL) 32 Query DELETE FROM field_data_field_short_name WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_field_short_name WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_data_field_sub_line_item WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_field_sub_line_item WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_field_sub_line_item (entity_type, entity_id, revision_id, bundle, delta, language, field_sub_line_item_value) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '645') 32 Query INSERT INTO field_revision_field_sub_line_item (entity_type, entity_id, revision_id, bundle, delta, language, field_sub_line_item_value) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', '645') 32 Query DELETE FROM field_data_field_css_class WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (language IN ('und')) 32 Query DELETE FROM field_revision_field_css_class WHERE (entity_type = 'commerce_line_item') AND (entity_id = '646') AND (revision_id = '646') AND (language IN ('und')) 32 Query INSERT INTO field_data_field_css_class (entity_type, entity_id, revision_id, bundle, delta, language, field_css_class_value, field_css_class_format) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', 'full_product', NULL) 32 Query INSERT INTO field_revision_field_css_class (entity_type, entity_id, revision_id, bundle, delta, language, field_css_class_value, field_css_class_format) VALUES ('commerce_line_item', '646', '646', 'product', '0', 'und', 'full_product', NULL) 32 Query DELETE FROM cache_field WHERE (cid = 'field:commerce_line_item:646') 32 Query commit 32 Query START TRANSACTION 32 Query SELECT revision.order_number AS order_number, revision.revision_id AS revision_id, revision.revision_uid AS revision_uid, revision.mail AS mail, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.revision_hostname AS revision_hostname, revision.data AS data, base.order_id AS order_id, base.type AS type, base.uid AS uid, base.created AS created, base.changed AS changed, base.hostname AS hostname FROM commerce_order base INNER JOIN commerce_order_revision revision ON revision.revision_id = base.revision_id WHERE (base.order_id IN ('3')) FOR UPDATE 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_order:3') 32 Query SELECT t.* FROM field_data_commerce_line_items t WHERE (entity_type = 'commerce_order') AND (entity_id IN ('3')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_order_total t WHERE (entity_type = 'commerce_order') AND (entity_id IN ('3')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_customer_billing t WHERE (entity_type = 'commerce_order') AND (entity_id IN ('3')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_customer_shipping t WHERE (entity_type = 'commerce_order') AND (entity_id IN ('3')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SAVEPOINT savepoint_1 32 Query SELECT 1 AS expression FROM cache_field cache_field WHERE ( (cid = 'field:commerce_order:3') ) FOR UPDATE 32 Query INSERT INTO cache_field (cid, serialized, created, expire, data) VALUES ('field:commerce_order:3', '1', '1325532865', '0', 'a:4:{s:19:\"commerce_line_items\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:12:\"line_item_id\";s:3:\"646\";}}}s:20:\"commerce_order_total\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:6:\"amount\";s:9:\"678803224\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:2:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:640380400;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:38422824;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}}}}}}s:25:\"commerce_customer_billing\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:10:\"profile_id\";s:1:\"1\";}}}s:26:\"commerce_customer_shipping\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:10:\"profile_id\";s:1:\"2\";}}}}') 32 Query RELEASE SAVEPOINT savepoint_1 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_order' AND entity_id IN ('3') 32 Query SAVEPOINT savepoint_1 32 Query SELECT base.line_item_id AS line_item_id, base.order_id AS order_id, base.type AS type, base.line_item_label AS line_item_label, base.quantity AS quantity, base.created AS created, base.changed AS changed, base.data AS data FROM commerce_line_item base WHERE (base.line_item_id IN ('646')) 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_line_item:646') 32 Query SELECT t.* FROM field_data_commerce_unit_price t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_total t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_product t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_commerce_display_path t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_field_short_name t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_field_sub_line_item t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SELECT t.* FROM field_data_field_css_class t WHERE (entity_type = 'commerce_line_item') AND (entity_id IN ('646')) AND (language IN ('und')) AND (deleted = '0') ORDER BY delta ASC 32 Query SAVEPOINT savepoint_2 32 Query SELECT 1 AS expression FROM cache_field cache_field WHERE ( (cid = 'field:commerce_line_item:646') ) FOR UPDATE 32 Query INSERT INTO cache_field (cid, serialized, created, expire, data) VALUES ('field:commerce_line_item:646', '1', '1325532865', '0', 'a:7:{s:19:\"commerce_unit_price\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:6:\"amount\";s:6:\"144100\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";s:6:\"144100\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:8646;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}}}}s:14:\"commerce_total\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:6:\"amount\";s:8:\"17436100\";s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:3:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:17436100;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:10:\"components\";a:0:{}}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:1046166;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}i:2;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:0;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}}}}}}s:16:\"commerce_product\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:10:\"product_id\";s:2:\"12\";}}}s:21:\"commerce_display_path\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:5:\"value\";s:0:\"\";s:6:\"format\";N;s:10:\"safe_value\";s:0:\"\";}}}s:16:\"field_short_name\";a:0:{}s:19:\"field_sub_line_item\";a:1:{s:3:\"und\";a:1:{i:0;a:1:{s:5:\"value\";s:5:\"645.0\";}}}s:15:\"field_css_class\";a:1:{s:3:\"und\";a:1:{i:0;a:3:{s:5:\"value\";s:12:\"full_product\";s:6:\"format\";N;s:10:\"safe_value\";s:12:\"full_product\";}}}}') 32 Query RELEASE SAVEPOINT savepoint_2 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_line_item' AND entity_id IN ('646') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('commerce_currencies:en') 32 Query SAVEPOINT savepoint_2 32 Query SELECT revision.order_number AS order_number, revision.revision_id AS revision_id, revision.revision_uid AS revision_uid, revision.mail AS mail, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.revision_hostname AS revision_hostname, revision.data AS data, base.order_id AS order_id, base.type AS type, base.uid AS uid, base.created AS created, base.changed AS changed, base.hostname AS hostname FROM commerce_order base INNER JOIN commerce_order_revision revision ON revision.revision_id = base.revision_id WHERE (base.order_id IN ('3')) FOR UPDATE 32 Query SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN ('field:commerce_order:3') 32 Query SELECT entity_id, feed_nid FROM feeds_item WHERE entity_type = 'commerce_order' AND entity_id IN ('3') 32 Query UPDATE commerce_order SET order_number='3', type='commerce_order', uid='1', mail='banderson@vectorworks.net', status='cart', created='1324404432', changed='1325532865', hostname='127.0.0.1', data='a:0:{}' WHERE (order_id = '3') 32 Query INSERT INTO commerce_order_revision (order_id, order_number, revision_uid, mail, status, log, revision_timestamp, revision_hostname, data) VALUES ('3', '3', '1', 'banderson@vectorworks.net', 'cart', 'Customer updated the order via the shopping cart form.', '1325532865', '127.0.0.1', 'a:0:{}') 32 Query UPDATE commerce_order SET revision_id='231' WHERE (order_id = '3') 32 Query RELEASE SAVEPOINT savepoint_2 32 Query DELETE FROM field_data_commerce_line_items WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_line_items WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '231') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_line_items (entity_type, entity_id, revision_id, bundle, delta, language, commerce_line_items_line_item_id) VALUES ('commerce_order', '3', '231', 'commerce_order', '0', 'und', '646') 32 Query INSERT INTO field_revision_commerce_line_items (entity_type, entity_id, revision_id, bundle, delta, language, commerce_line_items_line_item_id) VALUES ('commerce_order', '3', '231', 'commerce_order', '0', 'und', '646') 32 Query DELETE FROM field_data_commerce_order_total WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_order_total WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '231') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_order_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_order_total_amount, commerce_order_total_currency_code, commerce_order_total_data) VALUES ('commerce_order', '3', '231', 'commerce_order', '0', 'und', '18482266', 'USD', 'a:1:{s:10:\"components\";a:2:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:17436100;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:1046166;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}}}') 32 Query INSERT INTO field_revision_commerce_order_total (entity_type, entity_id, revision_id, bundle, delta, language, commerce_order_total_amount, commerce_order_total_currency_code, commerce_order_total_data) VALUES ('commerce_order', '3', '231', 'commerce_order', '0', 'und', '18482266', 'USD', 'a:1:{s:10:\"components\";a:2:{i:0;a:3:{s:4:\"name\";s:10:\"base_price\";s:5:\"price\";a:3:{s:6:\"amount\";i:17436100;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:0:{}}s:8:\"included\";b:1;}i:1;a:3:{s:4:\"name\";s:22:\"tax|maryland_sales_tax\";s:5:\"price\";a:3:{s:6:\"amount\";d:1046166;s:13:\"currency_code\";s:3:\"USD\";s:4:\"data\";a:1:{s:8:\"tax_rate\";a:12:{s:4:\"name\";s:18:\"maryland_sales_tax\";s:13:\"display_title\";s:18:\"Maryland Sales Tax\";s:11:\"description\";s:0:\"\";s:4:\"rate\";s:3:\".06\";s:4:\"type\";s:9:\"sales_tax\";s:15:\"rules_component\";s:36:\"commerce_tax_rate_maryland_sales_tax\";s:23:\"default_rules_component\";s:1:\"1\";s:15:\"price_component\";s:22:\"tax|maryland_sales_tax\";s:20:\"calculation_callback\";s:27:\"commerce_tax_rate_calculate\";s:6:\"module\";s:15:\"commerce_tax_ui\";s:5:\"title\";s:18:\"Maryland Sales Tax\";s:10:\"admin_list\";b:1;}}}s:8:\"included\";b:0;}}}') 32 Query DELETE FROM field_data_commerce_customer_billing WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_customer_billing WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '231') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_customer_billing (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_billing_profile_id) VALUES ('commerce_order', '3', '231', 'commerce_order', '0', 'und', '1') 32 Query INSERT INTO field_revision_commerce_customer_billing (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_billing_profile_id) VALUES ('commerce_order', '3', '231', 'commerce_order', '0', 'und', '1') 32 Query DELETE FROM field_data_commerce_customer_shipping WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (language IN ('und')) 32 Query DELETE FROM field_revision_commerce_customer_shipping WHERE (entity_type = 'commerce_order') AND (entity_id = '3') AND (revision_id = '231') AND (language IN ('und')) 32 Query INSERT INTO field_data_commerce_customer_shipping (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_shipping_profile_id) VALUES ('commerce_order', '3', '231', 'commerce_order', '0', 'und', '2') 32 Query INSERT INTO field_revision_commerce_customer_shipping (entity_type, entity_id, revision_id, bundle, delta, language, commerce_customer_shipping_profile_id) VALUES ('commerce_order', '3', '231', 'commerce_order', '0', 'und', '2') 32 Query DELETE FROM cache_field WHERE (cid = 'field:commerce_order:3') 32 Query DELETE FROM cache_commerce_shipping_rates WHERE (cid LIKE '3:%' ESCAPE '\\') 32 Query RELEASE SAVEPOINT savepoint_1 32 Query commit 32 Query DELETE FROM cache_form WHERE (cid = 'form_form-AWfJdv110I0uLLb5LKiI1iA2HjzVu5onOavKw8G1tlM') 32 Query DELETE FROM cache_form WHERE (cid = 'form_state_form-AWfJdv110I0uLLb5LKiI1iA2HjzVu5onOavKw8G1tlM') 32 Query INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES ('1', 'rules', 'Rules debug information: !log', 'a:1:{s:4:\"!log\";s:20231:\"