Query time 0.00122
JSON explain
{
"query_block": {
"select_id": 1,
"const_condition": "1",
"table": {
"table_name": "companies",
"access_type": "system",
"possible_keys": ["PRIMARY"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "company_descriptions",
"access_type": "system",
"possible_keys": ["PRIMARY"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_vendor_plan_descriptions",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "10",
"used_key_parts": ["plan_id", "lang_code"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "206",
"used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
"ref": ["const", "const", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_seo_names.`type` = 'm' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'ru')"
},
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": ["object_id"],
"key": "object_id",
"key_length": "6",
"used_key_parts": ["object_id", "object_type"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_discussion.object_type = 'M')"
},
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ALL",
"possible_keys": ["thread_id", "thread_id_2"],
"rows": 3,
"filtered": 100,
"attached_condition": "trigcond(cscart_discussion_posts.thread_id = cscart_discussion.thread_id and cscart_discussion_posts.`status` = 'A')"
},
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "thread_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["post_id"],
"ref": ["admin_test.cscart_discussion_posts.post_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_discussion_rating.thread_id = cscart_discussion.thread_id and trigcond(cscart_discussion_posts.post_id is not null))"
}
}
}
Result
company_id |
lang_code |
company_description |
i18n_company |
i18n_address |
i18n_city |
terms |
status |
company |
address |
city |
state |
country |
zipcode |
email |
phone |
url |
storefront |
secure_storefront |
entry_page |
redirect_customer |
countries_list |
timestamp |
shippings |
logos |
request_user_id |
request_account_name |
request_account_data |
tax_number |
registered_from_storefront_id |
agent_type |
plan_id |
pre_moderation |
pre_moderation_edit |
pre_moderation_edit_vendors |
robokassa_store_id |
robokassa_account_number |
suspend_date |
grace_period_start |
last_time_suspended |
last_debt_notification_time |
stripe_connect_account_id |
stripe_connect_account_type |
tinkoff_multiparty_shopcode |
tinkoff_multiparty_code |
tinkoff_multiparty_shop_data |
yandex_checkout_shopid |
yandex_checkout_marketplace_fee |
yandex_checkout_commission_type |
yandex_tax_code |
saved_shippings_state |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
9 |
ru |
|
Точка Связи |
|
|
|
A |
Точка Связи |
|
|
|
|
|
info@tochkasvyazi.ru |
|
|
|
|
none |
Y |
|
1716038756 |
14 |
|
0 |
|
|
772408578934 |
|
payment_agent |
4 |
N |
N |
N |
|
0 |
1716969311 |
0 |
1717842929 |
0 |
|
|
|
|
|
|
0.00 |
fixed |
0 |
14 |
Премиум |
tochkasvyazi |
|
|
9_0 |