Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.access_token AS access_token_2,
  t0.sync_token AS sync_token_3,
  t0.status AS status_4,
  t0.store AS store_5,
  t0.charge_id AS charge_id_6,
  t0.sync_status AS sync_status_7,
  t0.created_date AS created_date_8,
  t0.updated_date AS updated_date_9
FROM
  user t0
WHERE
  t0.store = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.sync_token AS sync_token_3, t0.status AS status_4, t0.store AS store_5, t0.charge_id AS charge_id_6, t0.sync_status AS sync_status_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9 FROM user t0 WHERE t0.store = 'jenstout5.myshopify.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.order_id AS order_id_3,
  t0.json AS json_4,
  t0.record_id AS record_id_5,
  t0.aed_sync AS aed_sync_6,
  t0.status AS status_7,
  t0.created_date AS created_date_8,
  t0.updated_date AS updated_date_9
FROM
  orders t0
WHERE
  t0.user_id = ?
  AND t0.order_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.order_id AS order_id_3, t0.json AS json_4, t0.record_id AS record_id_5, t0.aed_sync AS aed_sync_6, t0.status AS status_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9 FROM orders t0 WHERE t0.user_id = 14 AND t0.order_id = '6469283119175' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO orders (
  user_id, order_id, json, record_id,
  aed_sync, STATUS, created_date, updated_date
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO orders (user_id, order_id, json, record_id, aed_sync, STATUS, created_date, updated_date) VALUES (14, '6469283119175', '{\"id\":6469283119175,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/6469283119175\",\"app_id\":580111,\"browser_ip\":\"67.86.35.122\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWN8Ansq0M8OZTnxe306gzTu\",\"checkout_id\":58752789512263,\"checkout_token\":\"2e32700aa74b6edcc8c3ccc3c0e20631\",\"client_details\":{\"accept_language\":\"en-US\",\"browser_height\":null,\"browser_ip\":\"67.86.35.122\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/142.0.0.0 Safari\\/537.36\"},\"closed_at\":null,\"confirmation_number\":\"VD9QWF5LQ\",\"confirmed\":true,\"contact_email\":\"jennifer.stout@priority-software.com\",\"created_at\":\"2026-01-29T11:20:48-05:00\",\"currency\":\"USD\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"}},\"current_subtotal_price\":\"14.99\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"14.99\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"14.99\",\"currency_code\":\"USD\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"}},\"current_total_duties_set\":null,\"current_total_price\":\"19.89\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"19.89\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"19.89\",\"currency_code\":\"USD\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"}},\"customer_locale\":\"en-US\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"jennifer.stout@priority-software.com\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/password\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"18237915207\",\"merchant_of_record_app_id\":null,\"name\":\"!1028\",\"note\":null,\"note_attributes\":[],\"number\":28,\"order_number\":1028,\"order_status_url\":\"https:\\/\\/jenstout5.myshopify.com\\/64095551559\\/orders\\/be2a3706c0622c318f59e01582f1cf43\\/authenticate?key=d29c0186f80f65005f4899b8b25d8b19\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Cash on Delivery (COD)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"USD\",\"processed_at\":\"2026-01-29T11:20:46-05:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"14.99\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"14.99\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"14.99\",\"currency_code\":\"USD\"}},\"tags\":\"\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"be2a3706c0622c318f59e01582f1cf43\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"}},\"total_line_items_price\":\"14.99\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"14.99\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"14.99\",\"currency_code\":\"USD\"}},\"total_outstanding\":\"19.89\",\"total_price\":\"19.89\",\"total_price_set\":{\"shop_money\":{\"amount\":\"19.89\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"19.89\",\"currency_code\":\"USD\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-01-29T11:20:49-05:00\",\"user_id\":null,\"billing_address\":{\"first_name\":null,\"address1\":\"44 Mount View Street\",\"phone\":null,\"city\":\"Newton\",\"zip\":\"07860\",\"province\":\"New Jersey\",\"country\":\"United States\",\"last_name\":\"Tester\",\"address2\":null,\"company\":null,\"latitude\":41.0558326,\"longitude\":-74.7436361,\"name\":\"Tester\",\"country_code\":\"US\",\"province_code\":\"NJ\"},\"customer\":{\"id\":8050385911879,\"created_at\":\"2025-11-20T12:37:50-05:00\",\"updated_at\":\"2026-01-29T11:20:49-05:00\",\"first_name\":\"Jennifer\",\"last_name\":\"M Stout\",\"state\":\"disabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"jennifer.stout@priority-software.com\",\"phone\":null,\"currency\":\"USD\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/8050385911879\",\"default_address\":{\"id\":9419068309575,\"customer_id\":8050385911879,\"first_name\":null,\"last_name\":\"Tester\",\"company\":null,\"address1\":\"44 Mount View Street\",\"address2\":null,\"city\":\"Newton\",\"province\":\"New Jersey\",\"country\":\"United States\",\"zip\":\"07860\",\"phone\":null,\"name\":\"Tester\",\"province_code\":\"NJ\",\"country_code\":\"US\",\"country_name\":\"United States\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":15750460178503,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/15750460178503\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":1,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Large Green Tshirt\",\"price\":\"14.99\",\"price_set\":{\"shop_money\":{\"amount\":\"14.99\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"14.99\",\"currency_code\":\"USD\"}},\"product_exists\":true,\"product_id\":7414074376263,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"Green Shirt\",\"taxable\":true,\"title\":\"Large Green Tshirt\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"USD\"}},\"variant_id\":42444547522631,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"JenStout5\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":{\"first_name\":null,\"address1\":\"44 Mount View Street\",\"phone\":null,\"city\":\"Newton\",\"zip\":\"07860\",\"province\":\"New Jersey\",\"country\":\"United States\",\"last_name\":\"Tester\",\"address2\":null,\"company\":null,\"latitude\":41.0558326,\"longitude\":-74.7436361,\"name\":\"Tester\",\"country_code\":\"US\",\"province_code\":\"NJ\"},\"shipping_lines\":[{\"id\":5498633322567,\"carrier_identifier\":null,\"code\":\"Economy\",\"current_discounted_price_set\":{\"shop_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"}},\"discounted_price\":\"4.90\",\"discounted_price_set\":{\"shop_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"}},\"is_removed\":false,\"phone\":null,\"price\":\"4.90\",\"price_set\":{\"shop_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"},\"presentment_money\":{\"amount\":\"4.90\",\"currency_code\":\"USD\"}},\"requested_fulfillment_service_id\":null,\"source\":\"shopify\",\"title\":\"Economy\",\"tax_lines\":[],\"discount_allocations\":[]}],\"returns\":[],\"line_item_groups\":[]}', NULL, 'TO_BE_SYNCED', 'ACTIVE', '2026-01-29 16:20:50', '2026-01-29 16:20:50');

"COMMIT"

"COMMIT";