Query time 0.00084
JSON explain
{
"query_block": {
"select_id": 1,
"having_condition": "processor_status = 'A'",
"table": {
"table_name": "storefronts_payments",
"access_type": "system",
"possible_keys": ["PRIMARY", "idx_storefront_id"],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
},
"read_sorted_file": {
"filesort": {
"sort_key": "cscart_payments.position",
"table": {
"table_name": "cscart_payments",
"access_type": "ALL",
"rows": 9,
"filtered": 100,
"attached_condition": "cscart_payments.`status` = 'A'"
}
}
},
"table": {
"table_name": "cscart_payment_descriptions",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["payment_id", "lang_code"],
"ref": ["admin_test.cscart_payments.payment_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_payment_descriptions.lang_code = 'ru')"
},
"table": {
"table_name": "cscart_payment_processors",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["processor_id"],
"ref": ["admin_test.cscart_payments.processor_id"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_addons",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "98",
"used_key_parts": ["addon"],
"ref": ["admin_test.cscart_payment_processors.addon"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(trigcond(cscart_payment_processors.addon is not null))"
}
}
}
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 |
processor |
2 |
0 |
0 |
40 |
A |
views/orders/components/payments/empty.tpl |
0 |
|
0.000 |
0.000 |
|
|
tab3 |
dont_send |
Наш менеджер свяжется с вами |
Оплата в салоне удобным для вас способом |
|
|
ru |
A |
|
|
|
13 |
0 |
0 |
50 |
A |
views/orders/components/payments/cc_outside.tpl |
0 |
|
0.000 |
0.000 |
|
|
tab2 |
dont_send |
ЮMoney p2p |
|
<p>
Начните получать деньги прямо сейчас — от любых пользователей рунета. Переводы будут мгновенно зачисляться на ваш счет в ЮMoney.
</p> |
|
ru |
A |
|
|
|