Query time 0.00114
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.76"
},
"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": "vendor_plan_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_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": [
"plan_id",
"lang_code",
"plan"
]
}
},
{
"table": {
"table_name": "seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.85",
"eval_cost": "0.10",
"prefix_cost": "0.95",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "discussionA",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.67",
"eval_cost": "0.10",
"prefix_cost": "1.72",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"table": {
"table_name": "discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id_2",
"used_key_parts": [
"thread_id",
"status"
],
"key_length": "6",
"ref": [
"goimagine.discussionA.thread_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.18",
"prefix_cost": "2.15",
"data_read_per_join": "787"
},
"used_columns": [
"post_id",
"thread_id",
"status"
]
}
},
{
"table": {
"table_name": "discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"goimagine.discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.44",
"eval_cost": "0.18",
"prefix_cost": "2.76",
"data_read_per_join": "28"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(discussion_rating), (`goimagine`.`discussion_rating`.`thread_id` = `goimagine`.`discussionA`.`thread_id`), true)"
}
}
]
}
}
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 |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 3890 |
en |
<p></p>
<p><strong><b>I am the sole owner of Dale Rae Designs. I have around 50 years (yes, </b><b>I am </b><b>old!) of professional sewing experience: earned a degree in </b><b>theatrical costume design (worked in the field for 5 years), spent </b><b>10 years as a professional dressmaker, had an exercise and dance </b><b>wear business during the 80s and 15+ years designing and making </b><b>doll clothes for a variety of dolls. Additionally, I have taught </b><b>many sewing classes and workshops -- beginner - advanced.</b></strong></p>
<p><strong>Over the last 6 years I have sold my pop culture items at several local conventions. </strong></p>
<p><b><strong>In 2019 my sales booth at Denver Pop Culture Convention was named </strong></b><b><strong>one of the "top ten surprises from day one (May 31, 2019) at Denver Pop Culture Con" in the Denver Westworld publication. <a href="https://www.westword.com/arts/denver-pop-culture-con-is-full-of-nerdy-fun-at-colorado-convention-center-11363241">https://www.westword.com/arts/...</a> </strong></b></p> |
<p><strong>SHIPPING POLICY </strong></p><p>I ship all items via USPS with tracking - including international shipments. Shipping times will vary - USPS doesn't always deliver within the time frame they state, so if you need something quickly please upgrade your shipping option to reflect your requirement. If you prefer another shipping option, please contact me before placing an order. </p>
<p>I am not responsible for the time it takes for your item to arrive - once it is out of my hands, it is up to the USPS. </p>
<p>I generally DO ship in-stock items within 24 hours of receipt of the order - unless it is a USPS holiday and/or weather does not permit. Custom orders will be shipped upon completion - usually 3-7 days after order is place.</p>
<p>NOTE: I will not be responsible if you provide me with an incorrect address - please double check your information before submitting an order.</p><p><strong>RETURN & EXCHANGE POLICY</strong></p><p>I <strong>do not</strong> accept returns or exchanges on custom, personalized or sale items.</p>
<p><span class="wixGuard"></span><b>ALSO</b> - if you do not read/understand the sizing/fitting information I will not accept returns for items if you claim "it doesn't fit" or you "do not like the fit." I provide complete sizing/fitting information for all items. If you do not understand it, please contact me <strong>BEFORE</strong> ordering so I can help you can choose the proper size.</p>
<p><span class="wixGuard"></span>On in-stock items - if you are <strong>not</strong> satisfied with what you received, contact me within 5 days of receiving the order. </p>
<p>For returns, item(s) must be unworn/unwashed and buyer is responsible for return shipping.</p>
<p>Generally I do not do refunds - but an exchange only.</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":""} |
Dale Rae Designs |
18155 Augusta Drive |
Monument |
A |
Dale Rae Designs |
18155 Augusta Drive |
Monument |
CO |
US |
80132 |
daleraedesigns@comcast.net |
|
|
|
|
none |
Y |
|
1632757982 |
|
|
0 |
|
|
3 |
acct_1Jf4ZVJVKp7SdkSz |
|
171934 |
|
WDLXCQTZF82G2 |
Unique handmade apparel, accessories and stuff |
https://www.facebook.com/Dale-Rae-Designs |
https://www.instagram.com/daleraedesigns/ |
|
https://www.pinterest.com/DaleRaeDesigns/ |
<p>Welcome to Dale Rae Designs! I have been sewing for many years and love creating new things. If you are looking for something special but don't see it here (or on my website) please feel free to contact me.</p> |
|
|
|
208856368 |
|
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
Professional Plan |
dale-rae-designs |
|
5.0000 |
3890_852719 |