Query time 0.00016
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"table": {
"table_name": "cscart_companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "11K"
},
"used_columns": [
"company_id",
"status",
"company",
"lang_code",
"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",
"pre_moderation",
"pre_moderation_edit",
"pre_moderation_edit_vendors",
"plan_id",
"paypal_for_marketplaces_account_id",
"paypal_email",
"paypal_base_for_commission",
"paypal_verification",
"ppa_first_name",
"ppa_last_name",
"paypal_commerce_platform_account_id",
"suspend_date",
"grace_period_start",
"last_time_suspended",
"last_debt_notification_time",
"tax_number",
"saved_shippings_state",
"stripe_connect_account_id",
"stripe_connect_account_type",
"registered_from_storefront_id",
"shipstation_username",
"shipstation_password"
]
}
}
}
Result
| company_id |
status |
company |
lang_code |
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 |
pre_moderation |
pre_moderation_edit |
pre_moderation_edit_vendors |
plan_id |
paypal_for_marketplaces_account_id |
paypal_email |
paypal_base_for_commission |
paypal_verification |
ppa_first_name |
ppa_last_name |
paypal_commerce_platform_account_id |
suspend_date |
grace_period_start |
last_time_suspended |
last_debt_notification_time |
tax_number |
saved_shippings_state |
stripe_connect_account_id |
stripe_connect_account_type |
registered_from_storefront_id |
shipstation_username |
shipstation_password |
| 102 |
A |
Sophia's Shop |
en |
17 8th Ave |
New York |
NY |
|
10014 |
sophiashop221@gmail.com |
917-229-0099 |
|
|
|
none |
Y |
|
1727387925 |
18,13 |
|
0 |
|
|
N |
N |
N |
4 |
|
|
|
not_checked |
|
|
|
0 |
0 |
0 |
0 |
|
|
acct_1SAX0GRr4ccBhBbf |
E |
|
|
|