Query time 0.00117
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.28"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "0.12"
},
"nested_loop": [
{
"table": {
"table_name": "storefronts_payments",
"access_type": "system",
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"storefront_id",
"payment_id"
]
}
},
{
"table": {
"table_name": "cscart_payments",
"access_type": "ALL",
"rows_examined_per_scan": 12,
"rows_produced_per_join": 1,
"filtered": "10.00",
"cost_info": {
"read_cost": "1.79",
"eval_cost": "0.12",
"prefix_cost": "1.91",
"data_read_per_join": "3K"
},
"used_columns": [
"payment_id",
"company_id",
"usergroup_ids",
"position",
"status",
"template",
"processor_id",
"processor_params",
"a_surcharge",
"p_surcharge",
"tax_ids",
"localization",
"payment_category"
],
"attached_condition": "(`cscartdb`.`cscart_payments`.`status` = 'A')"
}
},
{
"table": {
"table_name": "cscart_payment_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"payment_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.cscart_payments.payment_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.12",
"prefix_cost": "2.03",
"data_read_per_join": "2K"
},
"used_columns": [
"payment_id",
"payment",
"description",
"instructions",
"surcharge_title",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_payment_processors",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"processor_id"
],
"key_length": "3",
"ref": [
"cscartdb.cscart_payments.processor_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "10.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "2.15",
"data_read_per_join": "381"
},
"used_columns": [
"processor_id",
"processor_script",
"type",
"addon"
],
"attached_condition": "(`cscartdb`.`cscart_payment_processors`.`processor_script` = 'stripe.php')"
}
},
{
"table": {
"table_name": "cscart_addons",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"addon"
],
"key_length": "98",
"ref": [
"cscartdb.cscart_payment_processors.addon"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "2.16",
"data_read_per_join": "227"
},
"used_columns": [
"addon",
"status"
]
}
}
]
}
}
}
Result
payment_id |
company_id |
usergroup_ids |
position |
status |
template |
processor_id |
processor_params |
a_surcharge |
p_surcharge |
tax_ids |
localization |
payment_category |
payment |
description |
instructions |
surcharge_title |
lang_code |
processor_status |
processor_type |
processor_script |
21 |
0 |
0 |
1 |
A |
addons/stripe/views/orders/components/payments/stripe.tpl |
111 |
a:11:{s:9:"is_stripe";s:1:"Y";s:7:"is_test";s:1:"N";s:10:"webhook_id";s:27:"we_1PaOTMG8KLo3uGXuI2mOV8ek";s:18:"webhook_secret_key";s:38:"whsec_DCcDQWh8KbyZLYrlhiPrrcsaoqE0jMgJ";s:15:"publishable_key";s:107:"pk_live_51PIX5XG8KLo3uGXuBIsHcy9Rg3Ue4y8KXSOlIF3M2xnLw8XhM8uY0B860jb7XXavQxCgamW05zCh4E84EOkAGYhV00RKOyt5vU";s:10:"secret_key";s:107:"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";s:19:"merchant_identifier";s:0:"";s:7:"country";s:2:"US";s:8:"currency";s:3:"USD";s:12:"payment_type";s:15:"stripe_checkout";s:19:"show_payment_button";s:1:"N";} |
0.000 |
0.000 |
|
|
tab1 |
Stripe |
|
|
|
en |
A |
P |
stripe.php |