Query time 0.00110
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.83"
},
"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.87",
"eval_cost": "0.10",
"prefix_cost": "0.97",
"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.72",
"eval_cost": "0.10",
"prefix_cost": "1.79",
"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.22",
"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.83",
"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 |
| 108 |
en |
<p><span class="display-block">Delano Designs is an environmentally friendly line of organic cotton home decor, bedding, and clothing items. Our items are unique, organic, and handmade. We are a</span> mother/daughter team based in Oregon, who are bringing their design dreams to life by helping you create a healthy and beautiful life you'll love.<br></p>
<p><span class="display-block"><em>And we proudly meet CPSC safety requirements for children's bedding and clothing.</em><br></span></p>
<p></p>
<p><br></p>
<p><span class="display-block"><br></span><br></p> |
<h4><span style="color: rgb(79, 97, 40);">Shipping</span></h4>
<ul><li>Shipping is free. </li><li>Please note shipping times stated in the listing.</li><li>All in stock items ship within 1-3 business days. </li><li>Items that are not currently in stock generally ship in 7-14 business days unless otherwise stated. </li><li>Shipping estimates for custom items will be given at the time of order. </li><li> The majority of items ship via USPS, either First Class or Priority mail. Larger orders may ship with other carriers.</li><li>We will do our best to meet the shipping estimates, but cannot guarantee them. Actual delivery time will depend on the shipping method. </li><li>We are not responsible for lost or damaged items. Shipping insurance is available upon request.</li><li>For shipping concerns or questions please contact us.</li></ul>
<p></p>
<h4><span style="color: rgb(79, 97, 40);">Refunds and Exchanges</span></h4>
<p>Your satisfaction is important to us. Please let us know as soon as possible if there is a problem with your order or products, and we will work with you to resolve the issue. Exchanges, returns, etc. will be determined on an individual basis. Items must not be washed or used prior to return. Custom items are not available to return. <br></p>
<h4><span style="color: rgb(79, 97, 40);">Cancellations</span></h4>
<p>We do not allow cancellations. Please contact us if you have any problems with your order.</p>
<h4><span style="color: rgb(79, 97, 40);">Additional Policies and Information</span></h4>
<p>All of our products have been made in a smoke-free environment.</p>
<p>All of our fabrics have been prewashed to prevent shrinkage, in a hypoallergenic, fragrance-free detergent.</p>
<p>We do our best to provide our customers with the most accurate photographs and descriptions of fabrics and products, however, please allow for some variations due to the color displays of different monitors.</p>
<p>The exact placement of the fabric may differ from the pictured item.<br></p>
<p>If you have specific concerns about a fabric, please contact us to be sure we can provide you with what you need. <br></p>
<p><br></p>
<p><br></p>
<p></p> |
{"tmenu_style":"H","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":""} |
Delano Designs |
2989 Eldridge Ave. |
Eugene |
A |
Delano Designs |
2989 Eldridge Ave. |
Eugene |
OR |
US |
97405 |
contact@delanodesignshome.com |
|
|
|
|
none |
Y |
|
1584563293 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:7:"Alison ";i:38;s:5:"Kelly";}s:15:"admin_firstname";s:7:"Alison ";s:14:"admin_lastname";s:5:"Kelly";s:6:"fields";a:0:{}} |
4 |
acct_1GOCbfHeRIyYAplS |
3990189227733635 |
65539,3545,144184,2591,154939,966 |
UA-177092501-1 |
F9S8RVFSAXZNA |
Earth Day Sale save 10% on all items. It's all about the fabric! Unique, organic and handmade items. |
https://www.facebook.com/DelanoDesigns |
https://www.instagram.com/delano_designs_home/ |
|
https://www.pinterest.com/delanodesigns/ |
<p><em><span style="color: rgb(192, 80, 77);"></span></em><br></p>
<p></p> |
oauth.Kq1VMWMgGgoXjGQbm7oTpQmHWLw7QCw6j4O0ZkXO.rDaCwoHQSm4F6o41HfCHXZknqzfZvxCMVzlaLgzKnp0 |
|
|
UA-177092501-1 |
3990189227733635 |
|
A |
|
|
{"items_per_file":"2500","time_from":"","time_to":""} |
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
All-Star Plan |
delanodesigns |
|
5.0000 |
108_3 |