Query time 0.00254
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.63"
},
"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.78",
"eval_cost": "0.10",
"prefix_cost": "0.88",
"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.61",
"eval_cost": "0.10",
"prefix_cost": "1.59",
"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.02",
"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.63",
"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 |
| 7837 |
en |
<p>Hi. My name is Mardi. Mardi is the French word for Tuesday, but for me, it’s a family name. I was born on a Sunday, and I make wire-wrapped bracelets in sterling silver, 14/20 gold-filled and Argentium silver. </p>
<p>A keen appreciation of aesthetics led me to study design in college. With a history of various hobbies as a maker of anything and everything, I was drawn to any hands-on opportunity to explore new materials, so I enrolled in a metalwork class. All the saws and hammers and torches and acids felt more like an intimidating science lab than an art studio. Metal and I, it seemed, were not to be friends. Ultimately I earned a degree in visual communication which has served me well. </p>
<p>Decades later, my mind still likes challenges and my hands continue to insist on being busy. Even so, my aversion to metal continued until several years ago when I met wire-wrapping—a technique requiring little more than some pliers, my humble hands, and the patience and love of precision needed to figure out patterns. Now I find the transformation of simple wire to a wearable work of art fun and gratifying…and not at all intimidating! </p>
<p>My bracelets are made of precious metal wire and nothing else. Styled like a bangle, some are narrow, some wider, some simple, some more ornate; some in a single metal, others in combination. They can be worn alone or in multiples. The designs are suitable for women and men. Sizing is based on wrist measurement. Every one of these pieces is created by hand—by my hands. No two are identical even if I am replicating a design.</p><p></p> |
<p>Like any handmade artist, the joy and satisfaction I feel in creating my work go in to each and every piece. Your happiness with your purchase is important to me. Please contact me if you have any questions at all. I try to respond within a timely manner, usually no more than two business days.</p>
<p><b>Sizing: </b></p>
<p>Each listing includes the size of the bracelet, the corresponding wrist measurement, a size chart and measuring information. While they do have a clasp<b>, </b>these are bangle-style bracelets and are intended to be worn somewhat loosely, but should not slip easily over the hand. I use an integral style of clasp exclusively because it is easy to maneuver with one hand and it stays hooked. However, it is not adjustable. </p>
<p>If possible, please measure the wrist of the intended wearer just below the hand, per the instructions. For a measurement that lands on the cusp of two sizes, the smaller size will fit more snugly, the larger will be a bit looser. Personal preference should be the deciding factor.</p>
<p>If you are purchasing a gift, please consult the size chart and use your best judgement. Should the size turn out to be unsatisfactory, please contact me. I will be happy to make an exchange, but please know that style options may be limited. </p>
<p><b>Care:</b></p>
<p>Like any precious metal jewelry, your bracelet may need to be polished now and then.</p>
<p><b>Processing Time and Shipping:</b></p>
<p>The item you see in the picture is the exact item you will receive. Each piece will be sent in a gift box with padding and a stretchy bow. </p>
<p>All domestic orders are shipped via USPS. If options are available, they will show at checkout. Items will be dispatched to the post office within 2-3 business days of when the order is submitted. Please add this to the carrier’s estimate to determine when to expect your order. </p>
<p><b>Returns and Exchanges: </b></p>
<p>Please contact me if you have any issue with your item. I want you to be happy with your purchase, and will do my best to work with you. </p>
<p>Should you wish to return or exchange an item, please contact me prior to sending it.</p>
<p>Please know that: </p>
<ul>
<li>You, the buyer, are responsible for the shipping costs. Please send your return with both tracking and insurance. </li>
<li>The item being returned should be in original condition <i>with the tag still attached</i>, and in the original gift box. </li>
<li>If the item is simply to be returned, the full purchase price less shipping will be issued once I have received the return. Shipping costs are not refundable—they were incurred by a third party who transported the package as they were paid to do.</li></ul>
<p><br></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":""} |
byTuesday |
|
Pittsburgh |
A |
byTuesday |
|
Pittsburgh |
PA |
US |
16046 |
bytuesday61@gmail.com |
+14122600511 |
|
|
|
none |
Y |
|
1666222158 |
|
|
0 |
|
|
1 |
acct_1LyPwRLDC8zzmOHE |
|
|
|
|
|
|
|
|
|
|
oauth.k5aTeRGDn6GU1z-W0ezX-zVyJPFtDSAEvA5GGBWQ.ZpuA8J2dQQDAPkJGhYw8CVB5aUVK84bqVqYO_f2hytk |
|
|
UA-250233430-1 |
|
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
Starter Plan |
bytuesday |
|
|
7837_0 |