Query time 0.00079
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 |
| 146 |
en |
<p>Hello! My name is Leha, and I am the artist for The Greene Bead. I specialize in wire wrapped and Polymer Clay jewelry, and I create miniature (indoor) fairy gardens. I try to use as much naturally derived product as I can, including all genuine gemstones, mined locally here in Wisconsin, Illinois and from around the world. Some of my pieces even include upcycled items such as vintage beads, crystals and buttons!<br></p>
<p><br>My journey began back in 2010 as a way to create new jewelry for myself, a broke college student, by taking apart jewelry I already owned and piecing it back together to create new items. One of my roommates at the time saw what I was doing and asked me to create a few pieces for him, and that's how this all started! <br><br>After many years of practice and improvement (I'm still improving everyday!), I've come to the point in my journey where I can start giving back. I've created many pieces to be used in silent auctions to raise money for my high school, my hometown library, benefits for friends and family to help with medical bills, and even Parkinson's research.<br><br>Last, but certainly not least, it is my personal goal to make sure each and every item I create for you is completely unique and that you are 100% satisfied with your order. Please feel free to message me with any questions, comments or concerns! I wish you all the best in your endeavors to find that perfect gift for yourself or someone you love.<br><br>If you would like to follow me on Social Media to stay updated on my local events calendar and the new pieces I am creating, you can find me here:<br><br>--> <a href="http://www.facebook.com/thegreenebead" target="_blank">Facebook</a> <--</p>
<p>--> <a href="http://www.instagram.com/the_greene_bead" target="_blank">Instagram</a> <--</p>
<p>--> <a href="http://www.youtube.com/tecichan2" target="_blank">YouTube <-- <br></a></p>
<p>--> <a href="mailto:tiktok.com/@thegreenebead" target="_blank">TikTok <--</a></p>
<p><a href="mailto:tiktok.com/@thegreenebead" target="_blank"><br><span style="color: rgb(51, 51, 51);">Watch my Meet the Maker video </span></a>--> <a href="https://youtu.be/wqt5dQLA1_M" target="_blank">here</a> <--<br></p> |
<p>SHIPPING POLICY: Domestic shipping for jewelry is sent by First Class bubble mailer (your items are protected in a jewelry box!). I am not responsible for any delays after item has shipped. If your item has been marked "delivered" but has not arrived, please file a 'lost package' claim with your Post Office. Often times, missing packages are with a neighbor, or still at the local office. If this has not resolved the issue within a few days, please contact me and I will do what I can to help you recover your package.<br></p>
<p><br>RETURN POLICY: I do not accept returns due to hygienic reasons, but there are of course, a few exceptions:<br>-Broken Upon Delivery: All items delivered broken by no fault of the buyer may be eligible for a full refund, in which I will ask for photographs of the packaging and item/s in order to issue you a refund if we cannot resolve a way to repair the item.<br>-Custom orders: Custom orders may not be returned, unless buyer receives broken (See Broken Upon Delivery)</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":"https:\/\/thegreenebead.goimagine.com\/holiday-seasonal\/spring\/","vbp_3_url":"","vba_1_url":"https:\/\/thegreenebead.goimagine.com\/holiday-seasonal\/spring\/","vba_2_url":"https:\/\/thegreenebead.goimagine.com\/holiday-seasonal\/mothers-day\/","vba_3_url":"https:\/\/thegreenebead.goimagine.com\/holiday-seasonal\/fathers-day-en-3\/"} |
The Greene Bead test algolia |
3512 Wright Ave |
Racines |
A |
The Greene Bead test algolia |
3512 Wright Ave |
Racines |
WY |
US |
53406 |
thegreenebead@yahoo.com |
|
|
|
|
none |
Y |
|
1584777007 |
|
|
31 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:7:"Telleha";i:38;s:9:"Cichantek";}s:15:"admin_firstname";s:7:"Telleha";s:14:"admin_lastname";s:9:"Cichantek";s:6:"fields";a:0:{}} |
3 |
acct_1GPD9oK0r41pp6yo |
482074193031327 |
289310,525,17300,11069,167569,46326 |
UA-131553366-2 |
|
Unique Gifts for a Unique You |
www.facebook.com/thegreenebead |
www.instagram.com/the_greene_bead |
|
www.pinterest.com/thegreenebead |
<p>UPCOMING EVENTS: </p>
<p>July 14th-16th: Elvis Fest, Vet's Hall, Necedah, WI</p>
<p>August 5th: Art in the Park, Lion's Park, Necedah, WI</p>
<p>September 23rd: Country Harvest Fest, TBD, Necedah, WI</p>
<p>October 28th: Art and Vendor Fair, Necedah Area School, Necedah, WI</p> |
|
|
|
UA-131553366-2 |
482074193031327 |
|
A |
|
|
{"items_per_file":"2500","time_from":"","time_to":""} |
Y |
1695373670 |
0 |
0 |
0 |
0 |
|
S |
|
7.50 |
onetime |
4.00 |
250 |
0.00 |
1 |
|
|