Query time 0.00531
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.05"
},
"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.90",
"eval_cost": "0.10",
"prefix_cost": "2.15",
"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.93",
"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.33",
"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.73",
"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.18",
"eval_cost": "0.02",
"prefix_cost": "5.93",
"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.99",
"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.05",
"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 |
| 27687 |
RCE4n1CN |
P |
A |
264 |
56.95 |
1 |
0.300 |
0 |
0 |
0 |
0.00 |
0 |
1593095849 |
1681817145 |
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:1;s:16:"max_items_in_box";i:4;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
0.000 |
0.000 |
|
|
|
2147483647 |
en |
Rainbow chainmaille choker |
|
<p>Rainbow chainmaille choker, striped necklace in European 4-in-1 pattern made with nickel free anodized aluminum by RainbowMaille</p> |
<p>Show your Rainbow Pride with this rainbow of European 4-in-1 pattern chainmaille in a diagonal stripe with a center triangle color pattern of rainbow 5/32" anodized aluminum rings with a large stainless steel lobster clasp. There is a full rainbow of rings with red at the center, necklace currently measures 16.5" inches long. </p>
<p>*Length can be adjusted upon request.</p> |
chainmaille choker, european 4-in-1 pattern, rainbow pride, pride necklace, chainmaille necklace, rainbowmaille, striped choker, rainbow stripes, striped chainmaille, nickel free, handmade, chain mail ooak, unique light weight jewelry, goimagine |
Rainbow chainmaille choker, striped necklace in European 4-in-1 pattern made with nickel free anodized aluminum by RainbowMaille |
chainmaille choker, european 4-in-1pattern, rainbow pride necklace, chainmaille necklace, rainbowmaille, striped choker, rainbow stripes, nickel free, handmade chainmaille, chain mail ooak, unique light weight jewelry |
Rainbow chainmaille choker |
|
<p>Ships next day</p> |
|
<p></p>
<p class="text-center"><strong>A glimpse into RainbowMaille's studio</strong></p>
<p></p>
<hr>
<p>Chainmaille is an addiction that pairs nicely with my OCD, counting out rings and lining them up in neat rows and patterns before assembly is very calming. There are many different types of rings not just sizes (diameter) or gauges (wire thickness) but actually different materials (metals), plus a nearly endless possibility of patterns. The majority of RainbowMaille's chainmaille is made with a rainbow of high quality anodized aluminum rings from TheRingLord. Although I do still occasionally work in smaller gold and silver plated rings and recently started using some EPDM rubber rings as well. </p>
<p><br></p>
<p>A note from TheRingLord about their process : <em> Made using a bright anodizing process, the result is a very consistent color batch that is shiny. The ends of these rings are not anodized as they are cut after anodizing. The anodizing process used to make these rings is FDA approved for cookware. Anodized aluminum coating is fairly hard but can be scratched with steel. We use a hard temper aluminum which is stronger than colored copper while being lighter than copper.</em></p>
<p><br></p>
<p>In order to reduce scratching or marring of rings while being worked my pliers are coated in a "plasti-dip" coating regularly. In order to reduce scratching and irritation of buyers I work hard to get my ring closures as close to perfect as possible, not just in side to side alignment but also top to bottom and closed tightly with no spaces or gaps. Misalignment or loose closures with spaces can lead to problems with snagging, ring stretching and breakage.</p> |
|
56.95000000 |
133M,13,4148,11980 |
4989 |
RainbowMaille |
<p>Welcome to RainbowMaille, I try to use only nickel-free and hypoallergenic materials in my jewelry, if I ever use anything that is not nickel-free the listing will specify that. The wall art is not made with nickel- free materials because it is not meant to be worn.</p>
<p><br></p>
<ul><li><strong><span style="color: rgb(149, 55, 52);">Returns and Cancellations</span></strong></li></ul>
<p>Returns are accepted within 14 days of delivery, money will be refunded after the product is returned. Return shipping costs are the responsibility of the buyer.<br><br>If an item is broken or damaged in shipping I will repair or replace it at no charge, please message me to make arrangements. 4rainbowmaille@gmail.com<br><br>Cancellations are accepted before orders ship but be warned I ship quickly often same day on completed items.<br>Cancellations requested after the 24-hour period will be decided on a case by case basis and may not be eligible for full refund if the order has already shipped.</p>
<p><br></p>
<ul><li><strong><span style="color: rgb(155, 187, 89);"><span style="color: rgb(149, 55, 52);">Shipping</span></span><span style="color: rgb(149, 55, 52);"></span></strong></li></ul>
<p>Once payment has been received/processed I will ship the order, most orders will ship within 1-3 days.<br>*You have a choice of shipping via USPS Priority mail or First-class package on most items, tracking is included.<br><br>Custom orders may take longer to ship depending on the size of the item.<br><br>*Please make sure to provide a correct/current address. I am not responsible for misdirected packages due to incorrect address information provided by the buyer.</p>
<p><br></p>
<ul><li><strong><span style="color: rgb(149, 55, 52);">Custom orders and wholesale</span></strong></li></ul>
<p>I will happily do custom orders for chainmaille jewelry or wire tree art, just contact me and tell me what you want. There is no design fee for custom work. However, if it requires the purchase of special materials there may be a variance from standard pricing.<br><br>I will not do wholesale due to the number of hours I put into each piece, although, I may offer some discounts on larger/multiple piece orders, email for details. 4rainbowmaille@gmail.com</p>
<p><br></p> |
rainbow-chainmaille-choker |
2/13/133 |
<p>Hello, my name is Amanda, I am a housewife, a cat lover and Maker of many things. It seems like I have always been crafting something. I learned to sew, crochet, and embroider from my grandmothers when I was young and that was just the beginning of my love of making things. I have gone through phases in my life where I have crafted many things, it seems like almost everything. I love embroidery, cross-stitch, and floral arranging but I have also made Christmas wreaths, scrapbooks, and leather crafts.<br></p>
<p><br>I started making chainmaille jewelry around 2012. It didn't take long for "playing with rings" to become an addiction. As I learned more chain patterns, I also learned to use better quality rings and materials. I still love light-weight, small silver- and gold-plated rings, but I also use a variety of anodized aluminum of various gauges and sizes. I am careful to make sure that all my rings are made with nickel-free materials, but occasionally some clasps and charms are not guaranteed nickel-free. I know lots of people have metal sensitives and allergies and I promise to clearly mark all of my products, so that you will always know what you are getting.<br><br>Part of why my chainmaille is priced higher than some others is because of the number of hours I spend on each piece. I probably could make things faster, but they would not be the quality I expect of myself. I am a bit O.C.D. so I tend to obsess over my ring closures. I know it's not possible to close every single ring perfectly, but I try. I aim for tight fits with good alignment not only side to side but top to bottom. In general, if I can see space/light then it's not right and I will do it again. I believe that gaps and misalignment lead to snagging and snagging leads to damage and breakage, so I work very hard to avoid that. </p>
<p>In recent years I have also started to make art in various other forms and mediums, from wire tree sculptures to paintings on canvas and the occasional combination. </p> |
D |