Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.platform_order_no AS platform_order_no_2,
  t0.pay_code AS pay_code_3,
  t0.merchant_order_no AS merchant_order_no_4,
  t0.channel_order_no AS channel_order_no_5,
  t0.amount AS amount_6,
  t0.paid_amount AS paid_amount_7,
  t0.refunded_amount AS refunded_amount_8,
  t0.refunding_amount AS refunding_amount_9,
  t0.risk_reserve_amount AS risk_reserve_amount_10,
  t0.platform_income_amount AS platform_income_amount_11,
  t0.merchant_settle_amount AS merchant_settle_amount_12,
  t0.proxy_profit_amount AS proxy_profit_amount_13,
  t0.status AS status_14,
  t0.settlement_status AS settlement_status_15,
  t0.type AS type_16,
  t0.client AS client_17,
  t0.client_locked AS client_locked_18,
  t0.order_name AS order_name_19,
  t0.order_desc AS order_desc_20,
  t0.notice_url AS notice_url_21,
  t0.return_url AS return_url_22,
  t0.client_ip AS client_ip_23,
  t0.merchant_param AS merchant_param_24,
  t0.pay_content AS pay_content_25,
  t0.remark AS remark_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.paid_at AS paid_at_29,
  t0.closed_at AS closed_at_30,
  t0.merchant_user_id AS merchant_user_id_31,
  t0.proxy_user_id AS proxy_user_id_32,
  t0.pay_channel_id AS pay_channel_id_33,
  t0.payment_provider_id AS payment_provider_id_34,
  t0.platform_config_id AS platform_config_id_35,
  t0.pricing_rule_id AS pricing_rule_id_36,
  t0.risk_reserve_config_id AS risk_reserve_config_id_37
FROM
  pay_order t0
WHERE
  t0.pay_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.platform_order_no AS platform_order_no_2, t0.pay_code AS pay_code_3, t0.merchant_order_no AS merchant_order_no_4, t0.channel_order_no AS channel_order_no_5, t0.amount AS amount_6, t0.paid_amount AS paid_amount_7, t0.refunded_amount AS refunded_amount_8, t0.refunding_amount AS refunding_amount_9, t0.risk_reserve_amount AS risk_reserve_amount_10, t0.platform_income_amount AS platform_income_amount_11, t0.merchant_settle_amount AS merchant_settle_amount_12, t0.proxy_profit_amount AS proxy_profit_amount_13, t0.status AS status_14, t0.settlement_status AS settlement_status_15, t0.type AS type_16, t0.client AS client_17, t0.client_locked AS client_locked_18, t0.order_name AS order_name_19, t0.order_desc AS order_desc_20, t0.notice_url AS notice_url_21, t0.return_url AS return_url_22, t0.client_ip AS client_ip_23, t0.merchant_param AS merchant_param_24, t0.pay_content AS pay_content_25, t0.remark AS remark_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.paid_at AS paid_at_29, t0.closed_at AS closed_at_30, t0.merchant_user_id AS merchant_user_id_31, t0.proxy_user_id AS proxy_user_id_32, t0.pay_channel_id AS pay_channel_id_33, t0.payment_provider_id AS payment_provider_id_34, t0.platform_config_id AS platform_config_id_35, t0.pricing_rule_id AS pricing_rule_id_36, t0.risk_reserve_config_id AS risk_reserve_config_id_37 FROM pay_order t0 WHERE t0.pay_code = '01KW3EQNDD27Y20K1NXSFGJ965' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.attempt_no AS attempt_no_2,
  t0.pay_method AS pay_method_3,
  t0.pay_type AS pay_type_4,
  t0.status AS status_5,
  t0.channel_order_no AS channel_order_no_6,
  t0.amount AS amount_7,
  t0.pay_content AS pay_content_8,
  t0.request_payload AS request_payload_9,
  t0.raw_response AS raw_response_10,
  t0.raw_notify AS raw_notify_11,
  t0.fail_reason AS fail_reason_12,
  t0.paid_at AS paid_at_13,
  t0.closed_at AS closed_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.pay_order_id AS pay_order_id_17,
  t0.merchant_user_id AS merchant_user_id_18,
  t0.proxy_user_id AS proxy_user_id_19,
  t0.pay_channel_id AS pay_channel_id_20,
  t0.payment_provider_id AS payment_provider_id_21,
  t0.routing_policy_id AS routing_policy_id_22
FROM
  payment_attempt t0
WHERE
  t0.attempt_no = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.attempt_no AS attempt_no_2, t0.pay_method AS pay_method_3, t0.pay_type AS pay_type_4, t0.status AS status_5, t0.channel_order_no AS channel_order_no_6, t0.amount AS amount_7, t0.pay_content AS pay_content_8, t0.request_payload AS request_payload_9, t0.raw_response AS raw_response_10, t0.raw_notify AS raw_notify_11, t0.fail_reason AS fail_reason_12, t0.paid_at AS paid_at_13, t0.closed_at AS closed_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.pay_order_id AS pay_order_id_17, t0.merchant_user_id AS merchant_user_id_18, t0.proxy_user_id AS proxy_user_id_19, t0.pay_channel_id AS pay_channel_id_20, t0.payment_provider_id AS payment_provider_id_21, t0.routing_policy_id AS routing_policy_id_22 FROM payment_attempt t0 WHERE t0.attempt_no = '202606271032306970588' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.attempt_no AS attempt_no_1,
  p0_.pay_method AS pay_method_2,
  p0_.pay_type AS pay_type_3,
  p0_.status AS status_4,
  p0_.channel_order_no AS channel_order_no_5,
  p0_.amount AS amount_6,
  p0_.pay_content AS pay_content_7,
  p0_.request_payload AS request_payload_8,
  p0_.raw_response AS raw_response_9,
  p0_.raw_notify AS raw_notify_10,
  p0_.fail_reason AS fail_reason_11,
  p0_.paid_at AS paid_at_12,
  p0_.closed_at AS closed_at_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.pay_order_id AS pay_order_id_16,
  p0_.merchant_user_id AS merchant_user_id_17,
  p0_.proxy_user_id AS proxy_user_id_18,
  p0_.pay_channel_id AS pay_channel_id_19,
  p0_.payment_provider_id AS payment_provider_id_20,
  p0_.routing_policy_id AS routing_policy_id_21
FROM
  payment_attempt p0_
WHERE
  p0_.pay_order_id = ?
  AND p0_.status IN (?)
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.attempt_no AS attempt_no_1, p0_.pay_method AS pay_method_2, p0_.pay_type AS pay_type_3, p0_.status AS status_4, p0_.channel_order_no AS channel_order_no_5, p0_.amount AS amount_6, p0_.pay_content AS pay_content_7, p0_.request_payload AS request_payload_8, p0_.raw_response AS raw_response_9, p0_.raw_notify AS raw_notify_10, p0_.fail_reason AS fail_reason_11, p0_.paid_at AS paid_at_12, p0_.closed_at AS closed_at_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.pay_order_id AS pay_order_id_16, p0_.merchant_user_id AS merchant_user_id_17, p0_.proxy_user_id AS proxy_user_id_18, p0_.pay_channel_id AS pay_channel_id_19, p0_.payment_provider_id AS payment_provider_id_20, p0_.routing_policy_id AS routing_policy_id_21 FROM payment_attempt p0_ WHERE p0_.pay_order_id = 74 AND p0_.status IN ('created', 'wait') ORDER BY p0_.id DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  1
FROM
  payment_attempt t0
WHERE
  t0.id = ? FOR
UPDATE

SELECT 1 FROM payment_attempt t0 WHERE t0.id = 214 FOR UPDATE;

SELECT
  1
FROM
  pay_order t0
WHERE
  t0.id = ? FOR
UPDATE

SELECT 1 FROM pay_order t0 WHERE t0.id = 74 FOR UPDATE;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.enabled AS enabled_3,
  t0.pay_methods AS pay_methods_4,
  t0.support_refund AS support_refund_5,
  t0.support_transfer AS support_transfer_6,
  t0.rate AS rate_7,
  t0.params AS params_8,
  t0.remark AS remark_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.payment_provider_id AS payment_provider_id_12
FROM
  pay_channel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.pay_methods AS pay_methods_4, t0.support_refund AS support_refund_5, t0.support_transfer AS support_transfer_6, t0.rate AS rate_7, t0.params AS params_8, t0.remark AS remark_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.payment_provider_id AS payment_provider_id_12 FROM pay_channel t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.doc_url AS doc_url_4,
  t0.api_base_url AS api_base_url_5,
  t0.capabilities AS capabilities_6,
  t0.supported_pay_methods AS supported_pay_methods_7,
  t0.config_schema AS config_schema_8,
  t0.remark AS remark_9,
  t0.enabled AS enabled_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  payment_provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.doc_url AS doc_url_4, t0.api_base_url AS api_base_url_5, t0.capabilities AS capabilities_6, t0.supported_pay_methods AS supported_pay_methods_7, t0.config_schema AS config_schema_8, t0.remark AS remark_9, t0.enabled AS enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM payment_provider t0 WHERE t0.id = 1;

UPDATE
  payment_attempt
SET
  raw_response = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE payment_attempt SET raw_response = '{\"content\":\"<form id=\'alipaysubmit\' name=\'alipaysubmit\' action=\'https:\\/\\/openapi.alipay.com\\/gateway.do?charset=utf-8\' method=\'POST\'><input type=\'hidden\' name=\'biz_content\' value=\'{\\\"out_trade_no\\\":\\\"202606271032267973932\\\",\\\"total_amount\\\":\\\"0.01\\\",\\\"subject\\\":\\\"\\u6d4b\\u8bd5\\u5546\\u54c1\\\",\\\"body\\\":\\\"\\u6d4b\\u8bd5\\u5546\\u54c1\\\",\\\"product_code\\\":\\\"FAST_INSTANT_TRADE_PAY\\\"}\'\\/><input type=\'hidden\' name=\'app_id\' value=\'2021005188663227\'\\/><input type=\'hidden\' name=\'version\' value=\'1.0\'\\/><input type=\'hidden\' name=\'format\' value=\'json\'\\/><input type=\'hidden\' name=\'sign_type\' value=\'RSA2\'\\/><input type=\'hidden\' name=\'method\' value=\'alipay.trade.page.pay\'\\/><input type=\'hidden\' name=\'timestamp\' value=\'2026-06-27 02:57:29\'\\/><input type=\'hidden\' name=\'alipay_sdk\' value=\'alipay-sdk-PHP-4.20.410.ALL\'\\/><input type=\'hidden\' name=\'notify_url\' value=\'https:\\/\\/pay.zjdainkj.com\\/api\\/payment_channel_notifications\\/alipay\'\\/><input type=\'hidden\' name=\'return_url\' value=\'https:\\/\\/pay.zjdainkj.com\\/api\\/pay_sessions\\/01KW3EQNDD27Y20K1NXSFGJ965\\/return\'\\/><input type=\'hidden\' name=\'charset\' value=\'utf-8\'\\/><input type=\'hidden\' name=\'app_cert_sn\' value=\'899b2e2e6cae8d170e57db1ada58ef37\'\\/><input type=\'hidden\' name=\'alipay_root_cert_sn\' value=\'687b59193f3f462dd5336e5abf83c5d8_02941eef3187dddf3d3b83462e1dfcf6\'\\/><input type=\'hidden\' name=\'sign\' value=\'JU9oJK23MeeIx9pR\\/wzn\\/vQTwIcbLD7s9h2VwB8MTqklxv0cRGwo8Qgiw\\/1\\/ILft2a9Qnu4NSsVj7jYJ8d+c1Kh\\/XzgjKZ0GNuZbq+16F3YdCe4gGN7UH9D1SlWIma3ZbDpehVKQMAHkaJCxWbiohyBUAUUzbL57MmmHQb\\/7GENUcVbZo3ja0GBL+MOzWkcMcSpp5mE\\/2j52S78Ze8qfUHHgavqgWfVnKbtWrH97BbuJiLucYhs2YweToGsDn1AfP+2gukuKFam2+t4FsDAtN25GqtrhLJkz7Pjqw1508dOVXObDyvW0x9cqbNLXVdwe\\/gTN+Itg5AsnuKFB7VuKhA==\'\\/><input type=\'submit\' value=\'ok\' style=\'display:none;\'\'><\\/form><script>document.forms[\'alipaysubmit\'].submit();<\\/script>\",\"providerSubmit\":{\"type\":\"redirect\",\"url\":\"https:\\/\\/unitradeprod.alipay.com\\/appAssign.htm?alipay_exterface_invoke_assign_target=invoke_e41f849abb4701da0b9197c0955b24b2&alipay_exterface_invoke_assign_sign=_fck_g_x_k8_au_sm_v8ob%2F_gj_bcvel_ucdlqr_g_c_r_d%2F57hi_d_w_n_z_k1_r_s6p_xt2r_z_q%3D%3D\",\"statusCode\":302,\"createdAt\":\"2026-06-27T03:45:54+00:00\"}}', updated_at = '2026-06-27 03:45:54' WHERE id = 214;

"COMMIT"

"COMMIT";