Query time 0.00312
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "8.26"
},
"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.27",
"eval_cost": "0.10",
"prefix_cost": "0.37",
"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.11",
"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.88",
"eval_cost": "0.10",
"prefix_cost": "2.09",
"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.88",
"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": 7,
"rows_produced_per_join": 7,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.75",
"eval_cost": "0.70",
"prefix_cost": "5.33",
"data_read_per_join": "112"
},
"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.75",
"eval_cost": "0.04",
"prefix_cost": "7.78",
"data_read_per_join": "938"
},
"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.30",
"eval_cost": "0.04",
"prefix_cost": "8.11",
"data_read_per_join": "607"
},
"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.04",
"prefix_cost": "8.19",
"data_read_per_join": "621"
},
"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.04",
"prefix_cost": "8.26",
"data_read_per_join": "8"
},
"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 |
| 3208 |
GSPCP |
P |
A |
146 |
0.00 |
1 |
0.122 |
0 |
0 |
0 |
0.00 |
0 |
1585851172 |
1678648296 |
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.950 |
|
|
|
2147483647 |
en |
Grey Shell and Pearl Polymer Clay Pendant |
|
<p>This grey Polymer Clay pendant has all the fixings! With a shell harvested from the Florida gulf beaches, this little pendant also hosts 3 different colored Freshwater Pearls in Peach, Silver and Brown.</p> |
<p>This exquisite Polymer Clay pendant exudes elegance with its stunning grey hue. Adorned with a seashell collected from the pristine beaches of Florida, it showcases the beauty of nature. Three radiant Freshwater Pearls in Peach, Silver and Brown add a pop of color, symbolizing the tears of the ocean. Its intricate Art Nouveau inspired design and compact size of 1.75 x 1 inch make it the perfect accessory for a beach day or a chic touch at a beach wedding. Ideal for gifting to a loved one born in June, this pendant is a timeless piece of jewelry to cherish for years to come. All pendants come with a Suede or Rope cord and are ready to wear! If you wish to have a custom Sterling Silver, Brass or Copper chain added to this pendant, please click --> <a href="https://goimagine.com/jewelry/custom-chain-add-on/" target="_blank">here</a> <--<br>*Due to screen variances, colors may not be accurately represented<br><br><b style="color: rgb(192, 80, 77);">**NOTE** This item in not sealed. To protect the piece, please do not wear while swimming or bathing.</b></p> |
Grey Florida Shell, Shell Jewelry, Gray Polymer Clay, Freshwater Pearl, Best Friend Birthday, Handmade Pendant, Handmade Jewelry, Beach Wedding, Ocean Themed Jewelry, Peach Silver Brown, Gulf of Mexico Shell, Mother's Day Present, Natural Necklace, Boss |
This gray Polymer Clay pendant has all the fixings! With a shell harvested from the Florida gulf beaches, this little pendant also hosts 3 different colored Freshwater Pearls in Peach, Silver and Brown. |
Grey Seashell Freshwater Pearl Polymer Clay Pendant, Beach Wedding Jewelry, June Birthstone Present, Ocean Lover Best Friend, Natural Shell Necklace, Mother's Day Gift, Boho Hippie Coworker, Unique Girlfriend Boss Aunt |
Grey Shell and Natural Freshwater Pearl Polymer Clay Pendant |
|
<p><span style="color: rgb(118, 146, 60);"></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>When I gathered this perfect shell off the beach in Destin, Florida, I knew exactly what I wanted to do with it! Keeping with the natural color of the shell, I chose a grey clay to create this piece with. To keep with the ocean theme, I used some very tiny, freshwater Pearls as accents. I chose the colors brown to represent the sea bed, blue to represent the water, and beige to represent the corals that this mollusk would have resided near.</p>
|
|
44.95000000 |
132M,114,532,1417,1421,21415 |
4972 |
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> |
greyshellpendant |
2/13/132 |
<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 |