Query time 0.00136
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.90"
},
"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.89",
"eval_cost": "0.10",
"prefix_cost": "0.99",
"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.77",
"eval_cost": "0.10",
"prefix_cost": "1.86",
"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.28",
"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.90",
"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 |
| 1192 |
en |
<p>I am a tomboy at heart and someone who is more comfortable in jeans and sandals rather then a skirt and heels, I've always leaned towards comfortable pieces of jewelry; the kind of jewelry that matched whatever I decided to wear that day. When I got the opportunity to create my own pieces, I discovered that they all shared a simple, common theme; comfortable, casual and natural, made from materials that I love and many of them even tell a story. My pieces are created for like minded women who love to be different. They embrace their imperfections because no one is perfect. They know that each imperfection makes us beautiful and one of a kind. None of us are polished, but we are resilient, just like my pieces. I use hand forged metals and I embrace all of the natural imperfections within them. Everything I create is for those beautiful women that not only have a dash of hippie, but a touch of explorer in their veins.</p> |
<p></p>
<h1><b style="font-size: 13px;">Processing</b><span style="font-size: 13px;"> </span><b style="font-size: 13px;">Time</b></h1>
<p>The time I need to prepare an order for shipping varies. For details, please see individual items descriptions.</p>
<p> </p>
<p><b>Estimated Shipping Times</b></p>
<p>I always do my best to meet shipping estimates, but they cannot be guaranteed. Actual shipping times will depend on whichever delivery method you have chosen during checkout.</p>
<p> </p>
<p><b>Returns </b></p>
<p>I do not accept returns unless there is a quality issue and not without prior approval first. Please contact us at contactnaturalisms@gmail.com within 3 days of delivery of your item. Items must be received back within 7 days from the time of delivery and in it's original condition (unopened and in original packaging) or buyer will be responsible for any loss of value. Buyer is responsible for the return shipping. <b>For hygienic reasons, all jewelry sales are final.</b></p>
<p><b>Refunds</b></p>
<p><b>For hygienic reasons, all jewelry sales are final.</b></p>
<p> </p>
<p><b>Exchanges</b> </p>
<p>I will gladly accept an exchange due to quality issues. <b>For hygienic reasons, all jewelry sales are final.</b></p>
<p>To exchange, please contact us at contactnaturalisms@gmail.com within 3 days of delivery. Items must be received back within 7 days from the time of delivery.</p>
<p>If the item is not returned in it's original condition (unopened and in original packaging), the buyer is responsible for any loss of value.</p>
<p>A replacement item will not be sent out until the original piece has been received and approved by me.<br></p>
<p> </p>
<p><b>Damages and issues</b>
Please inspect your order upon reception and contact us immediately if the item is defective, damaged or if you receive the wrong item, so that we can evaluate the issue and make it right. </p>
<p>Custom or personalized orders do not qualify for cancellation, return or exchange.</p>
<p> </p>
<p>You can always contact us for any return question at <a href="mailto:contactnaturalisms@gmail.com">contactnaturalisms@gmail.com</a>.</p>
<p><br></p> |
{"default_colors":"N","link_color":"#f9cb9c","label_color":"#f9cb9c","icon_color":"#8dd3d9","main_btn_color":"#6dd1d6","branded_text_color":"#000000"} |
Naturalisms |
541 Buckner Road |
Delano |
A |
Naturalisms |
541 Buckner Road |
Delano |
TN |
US |
37325 |
contactnaturalisms@gmail.com |
|
|
|
|
none |
Y |
|
1600074669 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:7:"Darlene";i:38;s:5:"Dugan";}s:15:"admin_firstname";s:7:"Darlene";s:14:"admin_lastname";s:5:"Dugan";s:6:"fields";a:0:{}} |
4 |
acct_1HRny6KeTD4tllbR |
|
|
|
|
Jewelry for women with a dash of hippie, and a touch of an explorer in their veins. |
www.facebook.com/naturalismshandcrafted |
www.instagram.com/naturalisms.handcrafted |
|
www.pinterest.com/naturalisms |
|
|
|
|
|
|
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
All-Star Plan |
naturalisms |
|
|
1192_0 |