Query time 0.00576
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.87"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "2.30"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_payments",
"access_type": "ALL",
"possible_keys": [
"c_status"
],
"rows_examined_per_scan": 11,
"rows_produced_per_join": 1,
"filtered": "10.00",
"cost_info": {
"read_cost": "1.64",
"eval_cost": "0.11",
"prefix_cost": "1.75",
"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",
"send_receipt"
],
"attached_condition": "((`test_uchur_k`.`cscart_payments`.`status` = 'A') and ((`test_uchur_k`.`cscart_payments`.`usergroup_ids` = '') or (0 <> find_in_set(0,`test_uchur_k`.`cscart_payments`.`usergroup_ids`)) or (0 <> find_in_set(1,`test_uchur_k`.`cscart_payments`.`usergroup_ids`))))"
}
},
{
"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": [
"test_uchur_k.cscart_payments.payment_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.28",
"eval_cost": "0.11",
"prefix_cost": "2.14",
"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": [
"test_uchur_k.cscart_payments.processor_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.28",
"eval_cost": "0.11",
"prefix_cost": "2.52",
"data_read_per_join": "3K"
},
"used_columns": [
"processor_id",
"processor_script",
"type",
"addon"
]
}
},
{
"table": {
"table_name": "cscart_addons",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"addon"
],
"key_length": "98",
"ref": [
"test_uchur_k.cscart_payment_processors.addon"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.28",
"eval_cost": "0.11",
"prefix_cost": "2.91",
"data_read_per_join": "2K"
},
"used_columns": [
"addon",
"status"
]
}
},
{
"table": {
"table_name": "storefronts_payments",
"access_type": "index",
"key": "PRIMARY",
"used_key_parts": [
"storefront_id",
"payment_id"
],
"key_length": "8",
"rows_examined_per_scan": 11,
"rows_produced_per_join": 2,
"filtered": "19.00",
"using_index": true,
"using_join_buffer": "hash join",
"cost_info": {
"read_cost": "1.44",
"eval_cost": "0.23",
"prefix_cost": "4.58",
"data_read_per_join": "36"
},
"used_columns": [
"storefront_id",
"payment_id"
],
"attached_condition": "(<if>(found_match(storefronts_payments), ((`test_uchur_k`.`storefronts_payments`.`storefront_id` = 1) or (`test_uchur_k`.`storefronts_payments`.`storefront_id` is null)), true) and <if>(is_not_null_compl(storefronts_payments), (`test_uchur_k`.`storefronts_payments`.`payment_id` = `test_uchur_k`.`cscart_payments`.`payment_id`), true))"
}
}
]
}
}
}
Result
| payment_id |
company_id |
usergroup_ids |
position |
status |
template |
processor_id |
processor_params |
a_surcharge |
p_surcharge |
tax_ids |
localization |
payment_category |
send_receipt |
payment |
description |
instructions |
surcharge_title |
lang_code |
processor_status |
processor_type |
processor_script |
| 19 |
1 |
0 |
0 |
A |
views/orders/components/payments/cc_outside.tpl |
138 |
a:10:{s:23:"send_prepayment_receipt";s:1:"Y";s:25:"send_full_payment_receipt";s:1:"Y";s:19:"send_refund_receipt";s:1:"N";s:20:"final_success_status";s:1:"C";s:11:"ffd_version";s:3:"1.2";s:9:"client_id";s:8:"UCHUR.KZ";s:10:"client_key";s:16:"jAqNqg$mYDKEw9hV";s:11:"terminal_id";s:36:"f68ca5b7-287f-42c0-8c57-66421fa4c4be";s:12:"kkb_currency";s:3:"KZT";s:8:"statuses";a:5:{s:7:"created";s:1:"O";s:6:"failed";s:1:"F";s:7:"succeed";s:1:"P";s:6:"refund";s:1:"E";s:8:"canceled";s:1:"D";}} |
0.000 |
0.000 |
|
|
tab1 |
dont_send |
Halyk Bank |
|
|
|
kk |
A |
P |
epay_halyk_bank.php |
| 20 |
1 |
0 |
0 |
A |
views/orders/components/payments/empty.tpl |
0 |
a:6:{s:23:"send_prepayment_receipt";s:1:"Y";s:25:"send_full_payment_receipt";s:1:"Y";s:19:"send_refund_receipt";s:1:"N";s:20:"final_success_status";s:1:"C";s:11:"ffd_version";s:3:"1.2";s:4:"atol";a:9:{s:8:"currency";s:3:"KZT";s:3:"sno";s:3:"osn";s:11:"api_version";s:1:"4";s:4:"mode";s:4:"test";s:8:"atol_inn";s:0:"";s:15:"atol_group_code";s:0:"";s:20:"atol_payment_address";s:0:"";s:10:"atol_login";s:0:"";s:13:"atol_password";s:0:"";}} |
0.000 |
0.000 |
|
|
tab1 |
dont_send |
Kaspi удаленная оплата |
|
|
|
kk |
A |
|
|
| 2 |
1 |
0 |
40 |
A |
views/orders/components/payments/phone.tpl |
0 |
|
0.000 |
0.000 |
|
|
tab3 |
dont_send |
Обсудить по телефону |
Наш менеджер позвонит вам. |
|
|
kk |
A |
|
|