Query time 0.00170
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.77"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status",
"idx_company_id",
"idx_usergroup_ids"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"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": "4K"
},
"used_columns": [
"product_id",
"product_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"is_returnable",
"return_period",
"avail_since",
"out_of_stock_actions",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"weight_lbs",
"weight_oz",
"product_tax_code",
"deleted_at",
"archived_at",
"position"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"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": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cd",
"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",
"terms"
]
}
},
{
"table": {
"table_name": "product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.31",
"eval_cost": "0.10",
"prefix_cost": "0.41",
"data_read_per_join": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(product_prices), ((`goimagine`.`product_prices`.`lower_limit` = 1) and (`goimagine`.`product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "11",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.64",
"eval_cost": "0.10",
"prefix_cost": "1.15",
"data_read_per_join": "5K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"cls_stop_words",
"how_its_made",
"custom_header"
]
}
},
{
"table": {
"table_name": "company_descr",
"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.87",
"eval_cost": "0.10",
"prefix_cost": "2.11",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"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.68",
"eval_cost": "0.10",
"prefix_cost": "2.90",
"data_read_per_join": "14K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`goimagine`.`companies`.`status` = 'A') or false), true)"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 5,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.25",
"eval_cost": "0.50",
"prefix_cost": "4.65",
"data_read_per_join": "80"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"goimagine.products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "1.25",
"eval_cost": "0.03",
"prefix_cost": "6.40",
"data_read_per_join": "670"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`goimagine`.`categories`.`storefront_id` in (0,1)) and ((`goimagine`.`categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`goimagine`.`categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`goimagine`.`categories`.`usergroup_ids`))) and (`goimagine`.`categories`.`status` in ('A','H')))"
}
},
{
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.22",
"eval_cost": "0.03",
"prefix_cost": "6.64",
"data_read_per_join": "434"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.04",
"eval_cost": "0.03",
"prefix_cost": "6.71",
"data_read_per_join": "444"
},
"used_columns": [
"company_id",
"lang_code",
"company_description"
]
}
},
{
"table": {
"table_name": "discussion",
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.04",
"eval_cost": "0.03",
"prefix_cost": "6.77",
"data_read_per_join": "6"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
}
]
}
}
}
Result
| product_id |
product_code |
product_type |
status |
company_id |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_timestamp |
usergroup_ids |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
is_returnable |
return_period |
avail_since |
out_of_stock_actions |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
options_type |
exceptions_type |
details_layout |
shipping_params |
weight_lbs |
weight_oz |
product_tax_code |
deleted_at |
archived_at |
position |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
cls_stop_words |
how_its_made |
custom_header |
price |
category_ids |
popularity |
company_name |
terms |
seo_name |
seo_path |
company_description |
discussion_type |
| 246605 |
QCB |
P |
A |
146 |
0.00 |
1 |
0.136 |
0 |
0 |
0 |
0.00 |
0 |
1661890660 |
1678400779 |
0 |
N |
N |
N |
B |
N |
R |
N |
N |
N |
Y |
10 |
0 |
N |
|
0 |
0 |
0 |
0 |
|
N |
0 |
P |
F |
|
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
0.000 |
2.180 |
|
|
|
2147483647 |
en |
Quartz Copper Bangle |
|
|
<p>Adorn your wrist with the stunning beauty of this Quartz bangle! Expertly crafted from delicate copper wires, this bracelet showcases a magnificent Milk Quartz bead in its center. This exquisite piece is not only a beautiful addition to any jewelry collection, but it is also a meaningful symbol of love and commitment. Copper, the traditional gift for a 7th wedding anniversary, is thought to symbolize strength and durability in a relationship. Meanwhile, Quartz, a stone of the Crown Chakra, is believed to amplify the power of other crystals and is said to bring clarity and peace to the wearer. The shimmering Milk Quartz, reminiscent of a fresh snowfall, adds a touch of serene elegance to the design. Measuring 8 inches on the inside of the band, this bracelet is the perfect fit for any wrist. Whether you're looking for a special gift for your wife, girlfriend, or a metaphysical practitioner, this gorgeous Quartz bangle is sure to delight.<br><em>*Due to screen variances, colors may not be accurately represented.<br><br></em><b><span style="color: rgb(192, 80, 77);">**NOTE** As with any metal, Copper may cause a reaction in some wearers. If you notice a reaction, please use a product like SkinGuard. This Copper is uncoated, and will naturally patina over time and with extended wear. If you wish to remove this patina, you may use any standard jewelry cleaner or a polishing cloth.</span></b></p> |
Milk Quartz Copper Wire Wrapped Bangle, Gemstone Bracelet, Crown Chakra Jewelry, 7th Wedding Anniversary Present, Metaphysical Reiki Practitioner Gifts, Wife Girlfriend Best Friend Birthday, Formal Wear Accessories |
Made from Copper wires, this bracelet hosts one solitary Milk Quartz bead. Copper is the traditional gift for a 7th wedding anniversary, and Quartz is a stone of the Crown Chakra. |
Milk Quartz Copper Wire Wrapped Bangle, Gemstone Bracelet, Crown Chakra Jewelry, 7th Wedding Anniversary Present, Metaphysical Reiki Practitioner Gifts, Wife Girlfriend Best Friend Birthday, Formal Wear Accessories |
Quartz Copper Bangle |
|
<p><span style="color: rgb(79, 97, 40);"></span></p>
<p><span style="color: rgb(79, 97, 40);">Packaged and Shipped in 1-3 Business Days</span></p>
<p><span style="color: rgb(79, 97, 40);"> |
|
<p>This bracelet was made with several different gauges of Copper wires and a single Milk Quartz bead.</p>
|
|
99.95000000 |
175M,171,531,1420,21415 |
1413 |
The Greene Bead test algolia |
<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> |
quartzcopperbangle |
2/18/175 |
<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> |
D |