Query time 0.00170
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.01"
},
"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.16",
"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.86",
"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": 4,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.40",
"prefix_cost": "4.30",
"data_read_per_join": "64"
},
"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.00",
"eval_cost": "0.02",
"prefix_cost": "5.70",
"data_read_per_join": "536"
},
"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.17",
"eval_cost": "0.02",
"prefix_cost": "5.89",
"data_read_per_join": "347"
},
"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.02",
"prefix_cost": "5.95",
"data_read_per_join": "355"
},
"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.02",
"prefix_cost": "6.01",
"data_read_per_join": "4"
},
"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 |
| 153263 |
AGSB |
P |
A |
146 |
0.00 |
7 |
0.117 |
0 |
0 |
0 |
0.00 |
0 |
1637178045 |
1679328256 |
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 |
1.870 |
|
|
|
2147483647 |
en |
Amazonite Gold Sterling Bracelet |
|
|
<p>Enhance your style with this stunning blue and gold bracelet, featuring vibrant Amazonite gemstones. This handcrafted piece was made with gold colored, Sterling Silver plated Copper wires, and showcases a beautiful beaded link design, adding a touch of elegance to your everyday look. Amazonite is revered for its emotional and spiritual benefits, making it the perfect gemstone for the Virgo zodiac and March birthdays. With its easy-to-use hook and eye clasp, this bracelet is not only fashionable, but also convenient to wear. Measuring 7.5 inches, it will effortlessly elevate your outfit and bring a pop of color to your wrist.<br>*<em>Due to screen variances, colors may not be accurately represented.<br><br></em><strong><span style="color: rgb(192, 80, 77);">**NOTE** Sterling Silver may cause a reaction in some wearers. If you notice a reaction, please use a product like Skin Guard. Sterling Silver will naturally patina over time and with extended wear. If you wish to remove this patina, you may use any standard Silver jewelry cleaner. Please do not wear while swimming or bathing, as this can cause the Silver to patina faster, and may damage the gemstones.</span></strong></p> |
Blue Green Amazonite Gold Colored Sterling Silver Gemstone Link Bracelet, March Virgo Zodiac Birthstone, Best Friend Birthday Gift, Metaphysical Reiki Jewelry, Homecoming Prom Dance Accessories, Secret Sister Santa Stocking Stuffer |
This bracelet was made with a beaded link style, and host Amazonite gemstones. Amazonite is one of the birthstones for the Virgo Zodiac, and an alternate birthstone for the month of March. |
Blue Green Amazonite Gold Colored Sterling Silver Gemstone Link Bracelet, March Virgo Zodiac Birthstone, Best Friend Birthday Gift, Metaphysical Reiki Jewelry, Homecoming Prom Dance Accessories, Secret Sister Santa Stocking Stuffer |
Amazonite Gold Sterling Bracelet |
|
<p><span style="color: rgb(118, 146, 60);"></span></p><p><span style="color: rgb(79, 97, 40);">Made and Shipped in 3-5 Business Days</span></p>
<p><span style="color: rgb(79, 97, 40);"> |
|
<p>This gorgeous Amazonite bracelet was handcrafted with gold colored Sterling Silver wire in a link style, and features a hook and eye clasp closure.</p>
|
|
44.95000000 |
531,1421,21415 |
1634 |
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> |
amazonitebracelet |
2/18/174 |
<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 |