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:\"\" Reacting on event Calculating the sell price of a product.
- 0 ms Reacting on event Calculating the sell price of a product.
\n- 2.789 ms Evaluating conditions of rule Calculate taxes: Sales tax. [edit]
\n- 2.8 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: Sales tax fires. [
edit]
- 0 ms Rule Calculate taxes: Sales tax fires.
\n- 0.131 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n\"
Executing rule
Calculate Maryland Sales Tax. [
edit]
- 0 ms Executing rule Calculate Maryland Sales Tax.
\n- 0.19 ms Evaluating conditions of rule Calculate Maryland Sales Tax. [edit]
\n- 0.198 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Maryland Sales Tax fires. [
edit]
- 0 ms Rule Calculate Maryland Sales Tax fires.
\n- 0.091 ms Evaluating the action commerce_tax_rate_apply. [edit]
\n- 0.63 ms Added the provided variable applied_tax of type commerce_price [edit]
\n- 0.659 ms Rule Calculate Maryland Sales Tax has fired.
\n
- 0.91 ms Finished executing of rule Calculate Maryland Sales Tax.
\n
- 5.785 ms Rule Calculate taxes: Sales tax has fired.
\n
- 8.658 ms Evaluating conditions of rule Calculate taxes: VAT. [edit]
\n- 8.666 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: VAT fires. [
edit]
- 0 ms Rule Calculate taxes: VAT fires.
\n- 0.088 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n- 0.839 ms Rule Calculate taxes: VAT has fired.
\n
- 9.544 ms Evaluating conditions of rule Calculate Price. [edit]
\n- 9.818 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 9.827 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Price fires. [
edit]
- 0 ms Rule Calculate Price fires.
\n- 32.946 ms Evaluating the action commerce_line_item_unit_price_amount. [edit]
\n- 33.742 ms Rule Calculate Price has fired.
\n
- 43.671 ms Evaluating conditions of rule Unset the price of disabled products in the cart. [edit]
\n- 43.988 ms The condition data_is_empty evaluated to FALSE [edit]
\n- 44.129 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 44.902 ms The condition data_is evaluated to FALSE [edit]
\n- 44.91 ms AND evaluated to FALSE.
\n- 44.924 ms Finished reacting on event Calculating the sell price of a product.
\n
\" Reacting on event Calculating the sell price of a product.
- 0 ms Reacting on event Calculating the sell price of a product.
\n- 0.198 ms Evaluating conditions of rule Calculate taxes: Sales tax. [edit]
\n- 0.21 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: Sales tax fires. [
edit]
- 0 ms Rule Calculate taxes: Sales tax fires.
\n- 0.082 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n\"
Executing rule
Calculate Maryland Sales Tax. [
edit]
- 0 ms Executing rule Calculate Maryland Sales Tax.
\n- 0.163 ms Evaluating conditions of rule Calculate Maryland Sales Tax. [edit]
\n- 0.172 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Maryland Sales Tax fires. [
edit]
- 0 ms Rule Calculate Maryland Sales Tax fires.
\n- 0.074 ms Evaluating the action commerce_tax_rate_apply. [edit]
\n- 0.564 ms Added the provided variable applied_tax of type commerce_price [edit]
\n- 0.583 ms Rule Calculate Maryland Sales Tax has fired.
\n
- 0.803 ms Finished executing of rule Calculate Maryland Sales Tax.
\n
- 1.728 ms Rule Calculate taxes: Sales tax has fired.
\n
- 1.982 ms Evaluating conditions of rule Calculate taxes: VAT. [edit]
\n- 1.99 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: VAT fires. [
edit]
- 0 ms Rule Calculate taxes: VAT fires.
\n- 0.07 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n- 0.79 ms Rule Calculate taxes: VAT has fired.
\n
- 2.816 ms Evaluating conditions of rule Calculate Price. [edit]
\n- 2.924 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 2.932 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Price fires. [
edit]
- 0 ms Rule Calculate Price fires.
\n- 30.402 ms Evaluating the action commerce_line_item_unit_price_amount. [edit]
\n- 30.967 ms Rule Calculate Price has fired.
\n
- 33.942 ms Evaluating conditions of rule Unset the price of disabled products in the cart. [edit]
\n- 34.072 ms The condition data_is_empty evaluated to FALSE [edit]
\n- 34.156 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 34.299 ms The condition data_is evaluated to FALSE [edit]
\n- 34.307 ms AND evaluated to FALSE.
\n- 34.326 ms Finished reacting on event Calculating the sell price of a product.
\n
\" Reacting on event After removing a product from the cart.
- 0 ms Reacting on event After removing a product from the cart.
\n- 0.38 ms Evaluating conditions of rule Reset the cart order status on product add or remove. [edit]
\n- 0.389 ms AND evaluated to TRUE.
\n\"
Rule
Reset the cart order status on product add or remove fires. [
edit]
- 0 ms Rule Reset the cart order status on product add or remove fires.
\n- 0.109 ms Evaluating the action commerce_order_update_status. [edit]
\n- 0.304 ms Rule Reset the cart order status on product add or remove has fired.
\n
- 0.729 ms Finished reacting on event After removing a product from the cart.
\n
\" Reacting on event After updating an existing commerce order.
- 0 ms Reacting on event After updating an existing commerce order.
\n- 0.241 ms Evaluating conditions of rule Delete shipping line items on shopping cart updates. [edit]
\n- 0.596 ms The condition data_is evaluated to TRUE [edit]
\n- 1.332 ms The condition data_is evaluated to TRUE [edit]
\n- 1.34 ms AND evaluated to FALSE.
\n- 1.353 ms Finished reacting on event After updating an existing commerce order.
\n
\" Reacting on event After updating an existing commerce order.
- 0 ms Reacting on event After updating an existing commerce order.
\n- 0.2 ms Evaluating conditions of rule Delete shipping line items on shopping cart updates. [edit]
\n- 0.385 ms The condition data_is evaluated to TRUE [edit]
\n- 0.632 ms The condition data_is evaluated to TRUE [edit]
\n- 0.64 ms AND evaluated to FALSE.
\n- 0.654 ms Finished reacting on event After updating an existing commerce order.
\n
\" Reacting on event After updating an existing commerce order.
- 0 ms Reacting on event After updating an existing commerce order.
\n- 0.207 ms Evaluating conditions of rule Delete shipping line items on shopping cart updates. [edit]
\n- 0.395 ms The condition data_is evaluated to TRUE [edit]
\n- 0.644 ms The condition data_is evaluated to TRUE [edit]
\n- 0.652 ms AND evaluated to FALSE.
\n- 0.666 ms Finished reacting on event After updating an existing commerce order.
\n
\" Reacting on event Calculating the sell price of a product.
- 0 ms Reacting on event Calculating the sell price of a product.
\n- 2.789 ms Evaluating conditions of rule Calculate taxes: Sales tax. [edit]
\n- 2.8 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: Sales tax fires. [
edit]
- 0 ms Rule Calculate taxes: Sales tax fires.
\n- 0.131 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n\"
Executing rule
Calculate Maryland Sales Tax. [
edit]
- 0 ms Executing rule Calculate Maryland Sales Tax.
\n- 0.19 ms Evaluating conditions of rule Calculate Maryland Sales Tax. [edit]
\n- 0.198 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Maryland Sales Tax fires. [
edit]
- 0 ms Rule Calculate Maryland Sales Tax fires.
\n- 0.091 ms Evaluating the action commerce_tax_rate_apply. [edit]
\n- 0.63 ms Added the provided variable applied_tax of type commerce_price [edit]
\n- 0.659 ms Rule Calculate Maryland Sales Tax has fired.
\n
- 0.91 ms Finished executing of rule Calculate Maryland Sales Tax.
\n
- 5.785 ms Rule Calculate taxes: Sales tax has fired.
\n
- 8.658 ms Evaluating conditions of rule Calculate taxes: VAT. [edit]
\n- 8.666 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: VAT fires. [
edit]
- 0 ms Rule Calculate taxes: VAT fires.
\n- 0.088 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n- 0.839 ms Rule Calculate taxes: VAT has fired.
\n
- 9.544 ms Evaluating conditions of rule Calculate Price. [edit]
\n- 9.818 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 9.827 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Price fires. [
edit]
- 0 ms Rule Calculate Price fires.
\n- 32.946 ms Evaluating the action commerce_line_item_unit_price_amount. [edit]
\n- 33.742 ms Rule Calculate Price has fired.
\n
- 43.671 ms Evaluating conditions of rule Unset the price of disabled products in the cart. [edit]
\n- 43.988 ms The condition data_is_empty evaluated to FALSE [edit]
\n- 44.129 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 44.902 ms The condition data_is evaluated to FALSE [edit]
\n- 44.91 ms AND evaluated to FALSE.
\n- 44.924 ms Finished reacting on event Calculating the sell price of a product.
\n
\" Reacting on event Calculating the sell price of a product.
- 0 ms Reacting on event Calculating the sell price of a product.
\n- 0.198 ms Evaluating conditions of rule Calculate taxes: Sales tax. [edit]
\n- 0.21 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: Sales tax fires. [
edit]
- 0 ms Rule Calculate taxes: Sales tax fires.
\n- 0.082 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n\"
Executing rule
Calculate Maryland Sales Tax. [
edit]
- 0 ms Executing rule Calculate Maryland Sales Tax.
\n- 0.163 ms Evaluating conditions of rule Calculate Maryland Sales Tax. [edit]
\n- 0.172 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Maryland Sales Tax fires. [
edit]
- 0 ms Rule Calculate Maryland Sales Tax fires.
\n- 0.074 ms Evaluating the action commerce_tax_rate_apply. [edit]
\n- 0.564 ms Added the provided variable applied_tax of type commerce_price [edit]
\n- 0.583 ms Rule Calculate Maryland Sales Tax has fired.
\n
- 0.803 ms Finished executing of rule Calculate Maryland Sales Tax.
\n
- 1.728 ms Rule Calculate taxes: Sales tax has fired.
\n
- 1.982 ms Evaluating conditions of rule Calculate taxes: VAT. [edit]
\n- 1.99 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: VAT fires. [
edit]
- 0 ms Rule Calculate taxes: VAT fires.
\n- 0.07 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n- 0.79 ms Rule Calculate taxes: VAT has fired.
\n
- 2.816 ms Evaluating conditions of rule Calculate Price. [edit]
\n- 2.924 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 2.932 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Price fires. [
edit]
- 0 ms Rule Calculate Price fires.
\n- 30.402 ms Evaluating the action commerce_line_item_unit_price_amount. [edit]
\n- 30.967 ms Rule Calculate Price has fired.
\n
- 33.942 ms Evaluating conditions of rule Unset the price of disabled products in the cart. [edit]
\n- 34.072 ms The condition data_is_empty evaluated to FALSE [edit]
\n- 34.156 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 34.299 ms The condition data_is evaluated to FALSE [edit]
\n- 34.307 ms AND evaluated to FALSE.
\n- 34.326 ms Finished reacting on event Calculating the sell price of a product.
\n
\" Reacting on event After removing a product from the cart.
- 0 ms Reacting on event After removing a product from the cart.
\n- 0.38 ms Evaluating conditions of rule Reset the cart order status on product add or remove. [edit]
\n- 0.389 ms AND evaluated to TRUE.
\n\"
Rule
Reset the cart order status on product add or remove fires. [
edit]
- 0 ms Rule Reset the cart order status on product add or remove fires.
\n- 0.109 ms Evaluating the action commerce_order_update_status. [edit]
\n- 0.304 ms Rule Reset the cart order status on product add or remove has fired.
\n
- 0.729 ms Finished reacting on event After removing a product from the cart.
\n
\" Reacting on event After updating an existing commerce order.
- 0 ms Reacting on event After updating an existing commerce order.
\n- 0.241 ms Evaluating conditions of rule Delete shipping line items on shopping cart updates. [edit]
\n- 0.596 ms The condition data_is evaluated to TRUE [edit]
\n- 1.332 ms The condition data_is evaluated to TRUE [edit]
\n- 1.34 ms AND evaluated to FALSE.
\n- 1.353 ms Finished reacting on event After updating an existing commerce order.
\n
\" Reacting on event After updating an existing commerce order.
- 0 ms Reacting on event After updating an existing commerce order.
\n- 0.2 ms Evaluating conditions of rule Delete shipping line items on shopping cart updates. [edit]
\n- 0.385 ms The condition data_is evaluated to TRUE [edit]
\n- 0.632 ms The condition data_is evaluated to TRUE [edit]
\n- 0.64 ms AND evaluated to FALSE.
\n- 0.654 ms Finished reacting on event After updating an existing commerce order.
\n
\" Reacting on event After updating an existing commerce order.
- 0 ms Reacting on event After updating an existing commerce order.
\n- 0.207 ms Evaluating conditions of rule Delete shipping line items on shopping cart updates. [edit]
\n- 0.395 ms The condition data_is evaluated to TRUE [edit]
\n- 0.644 ms The condition data_is evaluated to TRUE [edit]
\n- 0.652 ms AND evaluated to FALSE.
\n- 0.666 ms Finished reacting on event After updating an existing commerce order.
\n
\" Reacting on event Calculating the sell price of a product.
- 0 ms Reacting on event Calculating the sell price of a product.
\n- 2.42 ms Evaluating conditions of rule Calculate taxes: Sales tax. [edit]
\n- 2.43 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: Sales tax fires. [
edit]
- 0 ms Rule Calculate taxes: Sales tax fires.
\n- 0.105 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n\"
Executing rule
Calculate Maryland Sales Tax. [
edit]
- 0 ms Executing rule Calculate Maryland Sales Tax.
\n- 0.179 ms Evaluating conditions of rule Calculate Maryland Sales Tax. [edit]
\n- 0.188 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Maryland Sales Tax fires. [
edit]
- 0 ms Rule Calculate Maryland Sales Tax fires.
\n- 0.093 ms Evaluating the action commerce_tax_rate_apply. [edit]
\n- 0.618 ms Added the provided variable applied_tax of type commerce_price [edit]
\n- 0.638 ms Rule Calculate Maryland Sales Tax has fired.
\n
- 0.868 ms Finished executing of rule Calculate Maryland Sales Tax.
\n
- 6.564 ms Rule Calculate taxes: Sales tax has fired.
\n
- 9.067 ms Evaluating conditions of rule Calculate taxes: VAT. [edit]
\n- 9.076 ms AND evaluated to TRUE.
\n\"
Rule
Calculate taxes: VAT fires. [
edit]
- 0 ms Rule Calculate taxes: VAT fires.
\n- 0.097 ms Evaluating the action commerce_tax_calculate_by_type. [edit]
\n- 0.829 ms Rule Calculate taxes: VAT has fired.
\n
- 9.942 ms Evaluating conditions of rule Calculate Price. [edit]
\n- 10.182 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 10.191 ms AND evaluated to TRUE.
\n\"
Rule
Calculate Price fires. [
edit]
- 0 ms Rule Calculate Price fires.
\n- 31.201 ms Evaluating the action commerce_line_item_unit_price_amount. [edit]
\n- 31.949 ms Rule Calculate Price has fired.
\n
- 42.246 ms Evaluating conditions of rule Unset the price of disabled products in the cart. [edit]
\n- 42.535 ms The condition data_is_empty evaluated to FALSE [edit]
\n- 42.654 ms The condition entity_has_field evaluated to TRUE [edit]
\n- 43.309 ms The condition data_is evaluated to FALSE [edit]
\n- 43.317 ms AND evaluated to FALSE.
\n- 43.33 ms Finished reacting on event Calculating the sell price of a product.
\n