SELECT 
  processor_id, 
  processor_params 
FROM 
  cscart_payments 
WHERE 
  payment_id = 19

Query time 0.00011

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_payments",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["payment_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

Result

processor_id processor_params
111 a:11:{s:18:"is_paypal_checkout";s:1:"Y";s:10:"created_at";s:10:"1758805505";s:12:"access_token";s:97:"A21AANdRm9QiPrBQVNIw6mBOMxFiLN8VriSvTiVtiie0QZ0ojUT_1m2EkvJktPSq4tF1VY0uoH3oT1i0f3rjCpITLtLNUYEvQ";s:11:"expiry_time";s:10:"1770131171";s:9:"client_id";s:82:"BAAMI9QJMUdgcOrd78yELKz-CQZ7A-1gOFHjXEVOv_XdigjkjcZl6qGLL8BVMWHZTZsjbVvZm2YMTCUqko";s:6:"secret";s:80:"EEVI7j4xgCoyYL-GTuHBxxpIOvrY8Efecb4-DgfDkQav3OsVF1CG-TEhCq5VVPyeD6BixK5mn_0IxeKd";s:4:"mode";s:4:"live";s:8:"currency";s:3:"AUD";s:21:"send_shipping_address";s:1:"Y";s:15:"disable_funding";a:14:{s:4:"card";s:1:"0";s:8:"paylater";s:1:"0";s:6:"credit";s:1:"0";s:5:"venmo";s:1:"0";s:4:"sepa";s:1:"0";s:10:"bancontact";s:1:"0";s:3:"eps";s:1:"0";s:7:"giropay";s:1:"0";s:5:"ideal";s:1:"0";s:6:"mybank";s:1:"0";s:3:"p24";s:1:"0";s:6:"sofort";s:1:"0";s:11:"mercadopago";s:1:"0";s:4:"blik";s:1:"0";}s:5:"style";a:3:{s:5:"shape";s:4:"rect";s:5:"color";s:4:"blue";s:6:"height";s:2:"55";}}