Query time 0.00070
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"ordering_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "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": "14K"
},
"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",
"plan_id",
"stripe_connect_account_id",
"identifier_facebook_pixel",
"featured_products",
"sd_ga_tracking_code",
"paypal_commerce_platform_account_id",
"tagline",
"url_facebook",
"url_instagram",
"url_twitter",
"url_pinterest",
"announcement",
"shippo_api_token",
"shippo_carrier",
"shippo_service_type",
"vendor_ga_tracking_code",
"vendor_fb_tracking_code",
"custom_domain",
"custom_domain_status",
"taxjar_key",
"taxjar_export_statuses",
"taxjar_export_csv_data",
"ag_hide_city",
"updated_timestamp",
"suspend_date",
"grace_period_start",
"last_time_suspended",
"last_debt_notification_time",
"tax_number",
"stripe_connect_account_type",
"registered_from_storefront_id"
]
}
},
{
"table": {
"table_name": "company_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"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": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"company_description",
"terms",
"subdomain_colors",
"i18n_company",
"i18n_address",
"i18n_city"
]
}
},
{
"table": {
"table_name": "p",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_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": "112"
},
"used_columns": [
"plan_id",
"price",
"periodicity",
"commission",
"products_limit",
"revenue_limit",
"vendor_store",
"categories",
"storefronts"
]
}
}
]
}
}
}
Result
| company_id |
lang_code |
company_description |
terms |
subdomain_colors |
i18n_company |
i18n_address |
i18n_city |
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 |
plan_id |
stripe_connect_account_id |
identifier_facebook_pixel |
featured_products |
sd_ga_tracking_code |
paypal_commerce_platform_account_id |
tagline |
url_facebook |
url_instagram |
url_twitter |
url_pinterest |
announcement |
shippo_api_token |
shippo_carrier |
shippo_service_type |
vendor_ga_tracking_code |
vendor_fb_tracking_code |
custom_domain |
custom_domain_status |
taxjar_key |
taxjar_export_statuses |
taxjar_export_csv_data |
ag_hide_city |
updated_timestamp |
suspend_date |
grace_period_start |
last_time_suspended |
last_debt_notification_time |
tax_number |
stripe_connect_account_type |
registered_from_storefront_id |
price |
periodicity |
commission |
products_limit |
revenue_limit |
vendor_store |
categories |
storefronts |
| 733 |
en |
<p>Welcome to Dirty Name Ranch, home of The Bucking Mare! <br><br>I am inspired by all things organic, wild and free! Originally hailing from California, I was blessed to be transplanted into the wilds of Northeast Washington State in 2010 before moving deep into the Ozarks of Missouri in 2018. Creating, crafting, and being a part of nature has always been a part of who I am. I come from a family filled to the brim with like minded, crazy talented and artistic women so it was only natural that I would start to create, and create, and create. Needing an outlet for all this creating my husband and I took the leap and started Dirty Name Ranch in 2011. I create artisan made jewelry, accessories and more from under The Bucking Mare brand. All of my creations are hand-crafted and no two items are quite the same, whether it be a pair of earrings, saddle bling, prayer mala or hip flask. I use only high quality materials and traditional techniques to hand-tool, hand-knot and hand-stitch my creations. <br><br>Here at the Dirty Name Ranch we embrace the cowboy ways! We also believe that there is a Bucking Mare at the heart of every cowgirl! Wild, free, never truly tamed and lovin' the ride! We hope that you will join us in buckin' for the brand!</p> |
<p>All of our items are crafted with the upmost care and quality. If you are unsatisfied at any time or have an issue with your item please contact us right away so we can talk about how to make it right. </p> |
{"tmenu_style":"V","default_colors":"N","link_color":"#007d89","label_color":"#00a0af","icon_color":"#00a0af","main_btn_color":"#6dd1d6","branded_text_color":"#00a0af","vbp_1_url":"","vbp_2_url":"","vbp_3_url":"","vba_1_url":"","vba_2_url":"","vba_3_url":""} |
The Bucking Mare |
HC 73 Box 450 |
Drury |
A |
The Bucking Mare |
HC 73 Box 450 |
Drury |
MO |
US |
65638 |
Headmare@thebuckingmare.com |
|
|
|
|
none |
Y |
|
1592074394 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:5:"Tracy";i:38;s:6:"Nangle";}s:15:"admin_firstname";s:5:"Tracy";s:14:"admin_lastname";s:6:"Nangle";s:6:"fields";a:0:{}} |
3 |
acct_1Gu1g3A3NB9xwrGM |
|
92933,96332,92934,92935,92936,92937,264036 |
|
V7N46SHWL5RL4 |
"You were wild once, don't let them tame you." ~ Isadora Duncan |
|
www.instagram.com/thebuckingmare |
|
|
<p>Welcome to The Bucking Mare! </p>
<p>We are excited to have you stop in and sit a spell with us! We hope you enjoy your time with us and thank you for 'buckin' for the brand'!! </p> |
|
|
|
|
|
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
7.50 |
onetime |
4.00 |
250 |
0.00 |
1 |
|
|