Query time 0.00168
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.79"
},
"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.34",
"eval_cost": "0.10",
"prefix_cost": "0.44",
"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.65",
"eval_cost": "0.10",
"prefix_cost": "1.19",
"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.89",
"eval_cost": "0.10",
"prefix_cost": "2.17",
"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.96",
"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": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "3.31",
"data_read_per_join": "16"
},
"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": "0.25",
"eval_cost": "0.01",
"prefix_cost": "3.66",
"data_read_per_join": "134"
},
"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.04",
"eval_cost": "0.01",
"prefix_cost": "3.70",
"data_read_per_join": "86"
},
"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.01",
"prefix_cost": "3.75",
"data_read_per_join": "88"
},
"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.03",
"eval_cost": "0.01",
"prefix_cost": "3.79",
"data_read_per_join": "1"
},
"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 |
| 3132 |
N-0018 |
P |
A |
198 |
108.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1585780328 |
1597727010 |
0 |
N |
N |
N |
B |
Y |
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 |
0.000 |
|
|
|
2147483647 |
en |
Handmade Copper Penny Shaggy Loop Chainmaille Necklace |
|
<p>The Handmade Copper Penny Shaggy Loop Chainmaille Necklace features antique copper hand cut jump rings, Brown Mussell Shell Tags, tortoise transparent seed beads, cocoa lined seed beads, galvanized gold magatama seed beads, clear fringe beads, silver lined crystal AB seed beads, copper bicones, and gold plated lobster clasp</p> |
<p>The Handmade Copper Penny Shaggy Loop Chainmaille Necklace features the following:</p>
<p> </p>
<ul> <li>18G 3/16” antique copper hand cut jump rings</li> <li>Brown Mussell Shell Tags</li> <li>tortoise transparent seed beads</li> <li>cocoa lined seed beads</li> <li>galvanized gold 4×7 magatama seed beads</li> <li>4mm clear fringe beads</li> <li>silver lined crystal AB seed beads</li> <li>4mm copper bicones</li> <li>gold plated lobster clasp</li></ul>
<p> </p>
<p>This exquisite Handmade Copper Penny Shaggy Loop Chainmaille Necklace will become a favorite accessory for all of your outfits. This necklace is for the woman who loves to make a statement with their unique choice of fashion accessories. You will be sure to attract many admirers and receive numerous compliments with this statement necklace.</p>
<p> </p>
<p>You will feel like a queen wearing this beautiful classic piece of art.</p>
<p> </p>
<p>This artisan necklace would make a wonderful heirloom piece to hand down from generation to generation.<br></p>
<p> </p>
<p><strong>Your one of a kind piece of jewelry was created with much time and love. In addition this piece of art has been created especially for you.</strong></p>
<p> </p>
<p><strong>THIS PRODUCT INCLUDES USPS FIRST CLASS SHIPPING!!!!</strong></p>
<p></p>
<p></p>
<p></p>
<p>Visit me on social media</p>
<p><a href="http://www.instagram.com/couturejewelryheirloomlegacy" target="_blank">Instagram</a></p>
<p><a href="http://www.facebook.com/CoutureJewelrywithHeirloomLegacy" target="_blank">Facebook</a></p>
<p><a href="http://www.pinterest.com/couturejewelryheirloomlegacy" target="_blank">Pinterest</a></p>
<p><br></p>
<p>NOTE: Please
use care when wearing this necklace. The necklace is sturdy, but can be broken
if there is sudden pulling on the piece. Do not wear when swimming or
around water. Treat necklace as you would any other heirloom piece of
jewelry!</p>
<p> </p>
<p>Blessings and Grace with Beads and Lace</p> |
couture jewelry, handmade beaded jewelry, love couture jewelry, handmade artisan necklace, heirloom necklace, luxury necklace, high endnecklace, gifts for her, shaggy loop chainmaille necklace, go imagine seller, caring economy, made for good |
The Handmade Copper Penny Shaggy Loop Chainmaille Necklace features antique copper hand cut jump rings, Brown Mussell Shell Tags, tortoise transparent seed beads, cocoa lined seed beads, galvanized gold magatama seed beads, clear fringe beads, silver li |
couture jewelry, handmade beaded jewelry, love couture jewelry, handmade artisan necklace, heirloom jewelry necklace, luxury jewelry necklace, high end jewelry necklace, gifts for her necklace, gifts for women necklace, shaggy loop chainmaille necklace, jump ring necklace, special occasions jewelry, handmade bridal jewelry, handmade bridesmaid jewelry, go imagine seller, caring economy, made for good |
Handmade Copper Penny Shaggy Loop Chainmaille Necklace |
|
|
|
<p>This necklace is made with the chainmaille
technique called shaggy loop. The base is made with hand cut jump rings
woven into a chain. </p>
<p> </p>
<p>After the chain has been assembled crystals,
seed beads, and other beads are added to the chain </p>
<p>with
head pins and eye pins to give the "shaggy loop"
appearance. </p>
<p> </p>
<p>Chainmaille is very similar to beadweaving -
the main difference being that instead of weaving with needle, thread, and
beads you weave the jump rings in various ways. Using different weaving
techniques produces many gorgeous effects.</p>
|
|
86.00000000 |
137M |
5370 |
Couture Jewelry with Heirloom Legacy |
<p>PROCESSING TIME</p>
<p>Jewelry that is ready to ship will be available for shipping within 7 days. Orders may be shipped earlier, but are not guaranteed to be shipped prior to 7 days.</p>
<p><br></p>
<p>SELLING TO USA ONLY</p>
<p>Couture Jewelry doesn't offer shipping outside of the United States</p>
<p><br></p>
<p>CANCELLATIONS</p>
<p>Couture Jewelry does not offer cancellations. If there are any problems, please contact Couture Jewelry at info@couture-jewelry.com</p>
<p><br></p>
<p>GENERAL TERMS</p>
<p>Satisfaction is 100% guaranteed. If there should be any problems with an order, please contact me first before returning. </p>
<p>If after talking with you about your order you still wish to return the item please send back to Couture Jewelry in the original, unaltered condition and the original packaging within 14 days of purchase for a refund of the purchase price. If we have decided ahead of time you would like to exchange your purchased item for an equal value item, we can do this as well. </p>
<p>PLEASE DO NOT RETURN ANY ITEMS WITHOUT CONTACTING COUTURE JEWELRY FIRST. <strong>BUYER</strong> is responsible for shipping costs to send products back to Couture Jewelry. If the product is received not in original condition the <strong>BUYER</strong> is responsible for any loss in value.</p>
<p><strong>Returns or exchanges are not accepted on the following: </strong></p>
<p><strong></strong><br></p>
<ul><li><strong> Merchandise returned after 14 days from the original ship date </strong></li><li><strong> Personal items such as face masks</strong></li><li><strong> Custom Made Orders </strong></li><li><strong> Items that have been purchased on sale. </strong></li></ul>
<p>Refunds will be issued via Stripe once the merchandise has been received by Couture Jewelry. If you have any questions about your order, please do not hesitate to contact me by email at info@couture-jewelry.com</p>
<p><br></p>
<p><strong>NO RETURNS ON PERSONAL ITEMS SUCH AS FACE MASKS!</strong></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"><strong></strong><br></b></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"><br></b></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"><br></b><br></p>
<p><b class="_2K_N3" aria-expanded="false" data-hook="collapse-info-button"></b></p>
<p><b class="_2K_N3" aria-expanded="false" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; border-bottom-color: currentColor; border-bottom-style: none; border-bottom-width: 0px; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; border-left-color: currentColor; border-left-style: none; border-left-width: 0px; border-right-color: currentColor; border-right-style: none; border-right-width: 0px; border-top-color: currentColor; border-top-style: none; border-top-width: 0px; box-sizing: border-box; color: rgb(0, 0, 0); cursor: pointer; display: flex; font-family: wfont_890dd1_d811b5e3bc4b4d1fbcc513de8e39b099,wf_d811b5e3bc4b4d1fbcc513de8,orig_poppins_bold; font-size: 21px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: 26px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; outline-color: invert; outline-style: none; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; position: relative; text-align: inherit; text-decoration: inherit; vertical-align: baseline; width: 100%;" data-hook="collapse-info-button"><br></b></p> |
handmade-copper-penny-shaggy-loop-chainmaille-necklace |
2/13/137 |
<p>Teresa Delosh of Couture Jewelry specializes in handmade artisan jewelry that is designed to become family heirlooms for generations to come. I love to make jewelry that you will be proud to pass on to your family. I feature beadweaving, free standing lace, vinyl and leather jewelry. Now offering fashion accessories along with our jewelry.</p> |
|